Use SH database for this Write a select statement that returns Product name, Customer first name,...

 

Transcribed Image Text:

Use SH database for this 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 Write a select statement that returns channel ids that can be found in both sales and costs tables, do not repeat the redundant channel ids Write a select statement that return the customer id, first name, last name, and customer income level for the customers who live in the a city named 'Farmington'. Make sure to change income level 'K: 250,000 - 299.999 to 'KV: 250.000 - 299,999' in the result set 200 . 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 Instructions Deliver one.sql file that contains the questions and the select statements. . Use SH database for this 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 Write a select statement that returns channel ids that can be found in both sales and costs tables, do not repeat the redundant channel ids Write a select statement that return the customer id, first name, last name, and customer income level for the customers who live in the a city named 'Farmington'. Make sure to change income level 'K: 250,000 - 299.999 to 'KV: 250.000 - 299,999' in the result set 200 . 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 Instructions Deliver one.sql file that contains the questions and the select statements. .

Answer rating: 100% (QA)

Since you have not provided the schema details containing the table and column de... View the full answer