Below is a screenshot of the data that I'm working with. My challenge is to create a query that tells me which date has the greatest number of rows.
I was thinking that perhaps this might be a select within a select. Maybe something like select count(*)from (select id from calendar_look_alike group by date), but then I'm lost as far as how do I dictate that the only "count" I want is the one belonging to the date that the greatest "count" of rows?
What do you think?