In the analyze data with sql path there is a project listed that asks us to query the minimum date in an art collection to view the pieces as well as medium. I am referring to step #4 in the project
The way the solution does it seems a little counter intuitive to the purpose of querying. In my mind, I was hoping for a way to do it all in a single query. Why wouldn’t something like this work? Is there any way to go about doing it, there has to be.
SELECT title, medium FROM met WHERE date IS min(DATE);