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