THE met dates


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;

Hey @micro2635518921!

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

1 Like