Write SQL queries for the following questions.

1.

Write a select statement that returns Product name, Customer first name, Customer last

name, Channel description, and amount sold for all the sales. Make sure to returns sales even

if there is no information on the customer, product, or channel.

2.

Write a select statement (only one statement) that returns the sum of the sales amount sold

for all the customers, for customers in each province, and for customers in each city.

3.

Write a select statement to show the make, average ListPrice and total number of cars of

Black, Red or Blue color for each make where total count must be greater than 5 and average

ListPrice greater than 12000.

4.

Write a select statement to list the names and home phone numbers of customers who

purchased Jaguar XJRs.

5.

Write a select statement to find the makes, from which we have sold more than 40 cars?

Show the number of the cars sold.

6.

Write a select statement to display the car status as "Sold" or "For Sale", the serial numbers

and the models of sold and unsold 'Acura' cars. Use set operation to answer the query.