Scenario
Scenario
You are a data analyst and your manager has tasked you with analyzing some data. She has provided the following set of questions she would like answered.
Questions
- Which product has the highest price? Only return a single row.
- Which product has been bought the least in terms of quantity?
- Which customer has made the most orders?
- How many orders were placed in May, 2023?
- What’s the total revenue per product?
- Find the day with the highest revenue.
- Find the first order (by date) for each customer.
- Which product has been bought the least in terms of quantity?
- What is the median order total?
- For each order, determine if it was ‘Expensive’ (total over 300), ‘Affordable’ (total over 100), or ‘Cheap’.
- Find customers who have ordered the product with the highest price.
Submission Instructions
Place a comment below the post with your submission, then make a LinkedIn or twitter post with a screenshot or PDF of your answers. You can explain your thought process if you’d like. Just make sure to tag the Data in Motion LLC LinkedIn page or Twitter page.
DB Fiddle Instructions
Click ‘Edit on DB Fiddle’ to be taken to the in browser SQL playground where you can run your queries.