Hi all,

This is my first time posting thread in the forum since i have just registered
I came up to this forum through sqlcourse2.com where i'm learning SQL. So, it is clear to you that i'm still beginner in SQL

In this website there are two tables are used for the exercises; items_ordered & customers

My question: is it possible to know when was the minimum price and what was that

I thought it should be in the following manner: select min(price), order_date from items_ordered group by order_date;
But that didn't give me the desired output

Can anyone guide me to the solution ?
Thanks