THE met dates

Hi,

I am doing the activity for SQL where we are sorting the data for the MET art. I wanted to order the art so I had the data was sorted by the date and the date going from oldest to newest. (practice item #4). Why is the below code not doing that? what should I put for it to do so. Currently the activity wants me to find the min then use that to find the oldest, but I want to be able to order the whole list from oldest to newest

select date, title, medium
from met
group by date
order by date desc;

https://www.codecademy.com/paths/data-science/tracks/sql-intermediate/modules/dspath-sql-aggregates-projects-and-applications/projects/sql-the-met

Hey @micro2635518921!

Your code seems to work for me. When I run it, the dates are sorted from oldest to newest.

1 Like