Great. Let's have a look at the tables we're going to work with. If you've already had enough of cars and movies, here's a good piece of news: we're going to discuss orders and employees this time. We'll provide you with examples based on the table
orders (order_id, customer_id, order_date, ship_date, total_sum)
Not very complicated, as you can see.
Each order has an id (
order_id), was made by a specific customer (
customer_id) on a specific day (
order_date), as well as shipped on a specific day (
ship_date). The total value of the order is contained in the column