Question: Write SQL query to find the unique customer id from Orders. Write SQL query to sort the orders table by Order date ascending first and

Write SQL query to find the unique customer id from Orders.

Write SQL query to find the unique customer id from Orders.
Write SQL query to sort the orders table by Order date ascending first and then by amount descending.
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).

Consider the following 3 tables below. Customer Salesperson ID Name Age Salary 1 Abe 61 140000 2 Bob 34 44000 5 Chris 34 40000 7 Dan 41 8 Ken 57 115000 11 Joe 38 38000 ID Name City Industry Type 4 Samsonic pleasant 6 Panasung, oaktown 7 Samonx jackson B 9 Orange Jackson B 52000 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 7 150

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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...

The Customer _ Order table, which stores data about customer orders, contains the folowing data: Customer _ Order Prompt 2 Questions ( There are 8 questions for Prompt 2 ) . Write a query to retrieve...

A)Write a SQL query statement to list the details of all orders (using the OrderDetail view) in the descending order of the order date and the ascending order of customer id in the same order date....

Consider the following 3 tables below Customer Salesperson ID Name Age Salary 1 Abe 61 140000 2 Bob 34 44000 5. Chris 34 40000 7 Dani 41 52000 8 Ken 57 115000 11 Joe 38 38000 ID Name City Industry...

IDS 410 - Database Technology Individual Homework Assignment 4 Due Date: submit your solution file to the Blackboard by 11:59 PM on Feb 21, 2022 Instructions: - Download the attached Microsoft Access...

. Compose a query to list the number of customers in each state. In the result table, your query should show state and the number of customers in each state. Sort the results by state in ascending...

Create HR database with the following tables. Write SQL query for the following questions based on above database. No. Question 1. Write a SQL query to find those employees whose salaries are less...

For all the questions below write SQL query, Submit your queries in one pdf document. You only need to submit the query statement, no need to include resultset. The number at the end of the query...

Ineed answer for the last 5 questions For all the questions below write SQL query. Submit your queries in one pdf document. You only need to submit the query statement, no need to include resultset....

-- DDL for Table CUSTOMERT -------------------------------------------------------- CREATE TABLE "CUSTOMERT" ("CUSTOMER_ID" NUMBER(5,0), "CUST_NAME" VARCHAR2(30), "CITY" VARCHAR2(15), "GRADE"...

Refer to the preceding problem. Suppose 100 extra units had been acquired on December 30, 20X8, for $80 each, a total of $8,000. How would net income and income taxes have been affected under FIFO...

Write the structure of the carbinolamine intermediate and the imine product formed in the reaction of each of the following: (a) Acetaldehyde and benzylaminek, C6H5CH2NH2 (b) Benzaldehyde and...

Of the following types of mutual funds, an imvestor who wishes to invest in a diversified portfolio of foreign stocks ( excluding the U . S . ) should choose: Maltiple Choice International funds....

Journalize the following redemption transactions: 1. Oolong Corporation retired $130,000 face value bonds on June 30, 2017, at 103. The carrying value of the bonds at the redemption date was...