Database Management

--------------------------------------------------

Use SH database for this assignment - 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 - 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