SELECT click_date as date,
        COUNT(click_status) as numClicks
FROM clicks
WHERE click_status = 'SUCCESS' AND
        campaign_discriminator = (SELECT campaign_discriminator
                                   FROM campaigns
                                   WHERE campaign_name = 'clientX_texas_2018')
GROUP BY date