Question: Use SH database for this Write a select statement that returns Product name, Customer first name, customer last name, Channel description, and amount sold

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

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

Step by Step Solution

3.42 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

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

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!