Original query:

SELECT distinct date_of_run, count() as "number_titles"
FROM public.espn;



date_run	ID	Name	Description	Type	running	date_aired	time_aired
2020-06-08	8f661f20-217c-4d2f-ae8f-20a9050d64af	#21 Virginia Tech vs. Virginia (Softball)	Atlantic Coast Conference	On Demand	upcoming	2020-03-06	04:00:00 PM
2020-06-08	8742ccbf-bff2-42e7-b5b4-4e1def464a85	#7 NC State vs. Virginia (Baseball)	Atlantic Coast Conference	On Demand	upcoming	2020-03-06	04:00:00 PM
2020-06-08	cddb463c-01c6-4c32-a372-eb7dc41665a3	#14 Florida State vs. #12 Duke (Baseball)	Atlantic Coast Conference	On Demand	upcoming	2020-03-06	04:00:00 PM
2020-06-12	cb556115-c6c7-4f72-a62a-2763ea0a0510	Notre Dame vs. North Carolina (Baseball)	Atlantic Coast Conference	On Demand	upcoming	2020-03-06	03:00:00 PM
2020-06-12	bcb56d2f-f109-4973-b8dc-e0ec68d4c708	Syracuse vs. #4 Louisville (Quarterfinal)	Atlantic Coast Conference	On Demand	upcoming	2020-03-06	02:00:00 PM
2020-06-12	ba7c13ef-38ee-4eba-b4f5-3e2fafaf7a6e	ACC Women's Basketball Tournament Press Conference	Atlantic Coast Conference	On Demand	upcoming	2020-03-06	01:10:00 PM
2020-06-12	7b6f7386-c639-4542-b5f3-0009ff88588d	Duke Basketball Press Conference	Atlantic Coast Conference	On Demand	upcoming	2020-03-06	01:00:00 PM
2020-06-12	02e36240-0219-4356-8c81-e6a893677934	Wake Forest vs. #22 Florida State (Quarterfinal)	Atlantic Coast Conference	On Demand	upcoming	2020-03-06	11:00:00 AM
2020-06-12	4063fe2a-9fab-4d75-b9eb-f01c434098a0	Clemson vs. Boston College (Second Round, Game 4)	Atlantic Coast Conference	On Demand	upcoming	2020-03-05	08:00:00 PM
2020-06-12	a74d1a12-109e-46bd-b1f7-87c59363625c	Louisville vs. #1 North Carolina (W Lacrosse)	Atlantic Coast Conference	On Demand	upcoming	2020-03-05	07:00:00 PM
2020-06-12	233489c0-6890-42de-9e40-6c8a87671db4	Pittsburgh vs. Georgia Tech (Second Round, Game 3)	Atlantic Coast Conference	On Demand	upcoming	2020-03-05	06:00:00 PM
2020-06-14	e6b4f1bb-b2ca-40da-b8a9-13dcf2f62ed1	Virginia vs. Syracuse (Second Round, Game 2)	Atlantic Coast Conference	On Demand	upcoming	2020-03-05	02:00:00 PM
2020-06-14	31322f27-41f9-446e-8f0f-f24c21ab893c	North Carolina Basketball Press Conference	Atlantic Coast Conference	On Demand	upcoming	2020-03-05	02:00:00 PM
2020-06-14	7f59d523-2d09-4f9d-9be3-80c1ea84efae	Wake Forest vs. Virginia Tech (Second Round, Game 1)	Atlantic Coast Conference	On Demand	upcoming	2020-03-05	11:00:00 AM
2020-06-14	083f0f60-6569-48f5-a6d6-51698b56de01	Pittsburgh vs. Georgia Tech (M Basketball)	Atlantic Coast Conference	On Demand	upcoming	2020-03-04	09:00:00 PM
2020-06-14	aacd77dc-a90e-474a-895a-3503704c0dfd	#22 Virginia vs. Miami (M Basketball)	Atlantic Coast Conference	On Demand	upcoming	2020-03-04	09:00:00 PM
2020-06-16	08afb0fd-c265-4cfd-a3cb-9cd0354f81ca	ACC Women's Basketball Tournament Press Conference - Clemson vs Miami	Atlantic Coast Conference	On Demand	upcoming	2020-03-04	08:40:00 PM
2020-06-16	0c371ec7-76b3-4a18-94be-bc43f4a54b78	Clemson vs. Virginia Tech (M Basketball)	Atlantic Coast Conference	On Demand	upcoming	2020-03-04	07:00:00 PM
2020-06-16	1e8ee137-f479-4fd6-ab79-ea2cfc764013	Clemson vs. Miami (First Round, Game 3)	Atlantic Coast Conference	On Demand	upcoming	2020-03-04	06:30:00 PM
2020-06-16	7f89b9c4-da25-4bf9-a95c-4b71cb778cbb	ACC Women's Basketball Tournament Press Conference - Pittsburgh vs Notre Dame	Atlantic Coast Conference	On Demand	upcoming	2020-03-04	05:40:00 PM
2020-06-16	9af9f212-ad34-48b7-a038-56febf0f1dfb	George Mason vs. #10 Virginia (W Lacrosse)	Atlantic Coast Conference	On Demand	upcoming	2020-03-04	05:00:00 PM
2020-06-16	0e7ce833-d2b4-4214-9f0f-ed3cc73e4971	Campbell vs. #12 Duke (Baseball)	Atlantic Coast Conference	On Demand	upcoming	2020-03-04	04:00:00 PM