SELECT page_title, DATE_FORMAT(LEFT(rev_timestamp, 8), '%Y-%m-%d') AS date, COUNT(*)

FROM revision

JOIN page

  ON page_id = rev_page

WHERE page_namespace = 0

  AND ((page_title = 'Joe_Biden' AND rev_timestamp BETWEEN '20210120' AND '20210311')

       OR (page_title = 'Donald_Trump' AND rev_timestamp BETWEEN '20170120' AND '20170311')

       OR (page_title = 'Barack_Obama' AND rev_timestamp BETWEEN '20090120' AND '20090311'))

GROUP BY page_title, LEFT(rev_timestamp, 8);