Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Salesperson Customer ID Name Age Salary 1 Abe 61 140000 2 Bob 34 44000 5 Chris 34 40000 7 Dan 41 52000 8 Ken 57
Salesperson | Customer | ||||||||||||||||||||||||||||||||||||||||||||||||
|
|
Orders | ||||||||||||||||||||||||||||||||||||||||
|
- Write SQL query to find the unique customer id from Orders.
Write SQL query in the box below (Text Format Only) [1 Marks] |
|
- Write SQL query to sort the orders table by Order date ascending first and then by amount descending.
Write SQL query in the box below (Text Format Only) [2 Marks] |
|
- Write SQL query to find the total amount of sales done by each salesperson_id from the Orders table (Hint: GROUP BY is needed here).
Write SQL query in the box below (Text Format Only) [2 Marks] |
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started