Use SH database for this question

$$ 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 returns the customer id$,$ first name, last name, and customer income level for the customers who live in a city named 'Farmington'. Make sure to change income level $\text{'}$K: $250,000-299,999\text{'}$ to $\text{'}$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

Instructions

$$ Deliver one $.$sql file that contains the questions and the select statements. Also, you need to take a screenshot of your results as pdf file and send them to me$.$