Question: [Marks 10] Question 4: Queries Using SQL Write following SQL Queries: 1. 2. List the order number, order date, customer number, customer name (first and
![[Marks 10] Question 4: Queries Using SQL Write following SQL Queries:](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f4f4a1b3a20_44166f4f4a1903f8.jpg)
[Marks 10] Question 4: Queries Using SQL Write following SQL Queries: 1. 2. List the order number, order date, customer number, customer name (first and last), employee number, and employee name (first and last) of January 2017 orders placed by Colorado customers. List the customer number, name (first and last), order number, order date, employee number, employee name (first and last), product number, product name, and order cost (OrdLine.Qty * ProdPrice) for products ordered on January 23, 2017, in which the order cost exceeds $150. List the order number and total amount for orders placed on January 23, 2017. The total amount of an order is the sum of the quantity times the product price of each product on the order. List the order number, order date, customer name (first and last), and total amount for orders placed on January 23, 2017. The total amount of an order is the sum of the quantity times the product price of each product on the order. 3. 4
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
