Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
- 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] |
|
Consider the following 3 tables below. Customer Salesperson 78 Name Age Salary 1 Abe 61 140000 2 Bob 34 44000 ID Name City Industry Type 4 Samsonic pleasant 6 Panasung oaktown J 7 Samony jackson B 9 Orange Jackson B 5 Chris 34 40000 7 Dan 41 52000 8 Ken 57 115000 11 Joe 38 38000 Orders Number order date cust id salesperson id Amount 10 8/2/96 4 2 540 20 1/30/99 4 8 1800 30 7/14/95 9 1 460 40 1/29/98 7 2 2400 50 2/3/98 6 7 600 60 3/2/98 6 7 720 70 5/6/98 9 9 7 150
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