SELECT count(*) FROM  creatives WHERE DATE(creative_last_seen) >= SUBDATE(CURDATE(), 1 ) AND DATE(creative_last_seen) < curdate();

SELECT count(*) FROM  creatives WHERE creative_last_seen >= SUBDATE(CURDATE(), 1 ) AND creative_last_seen < curdate();