-
what is the command for this ...
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|