so i have the following table and want to create a query that will output the days it was most requested. for example on 01/02/2000 there was 3 requests in total, on 02/02/2000 there was 2 request in total, on 03/03/2000 there was 6 request in total and on 04/02/2000 there was 4 request in total. so basically i want to output this in table is that possible or will it be easier to just create another table with all this info and make dates a foreign key?
CodePudding user response:
use group by count like this
select Date,Count(Date) as Total from Table Group by Date