Guaranteed upvote for the correct answer!

* 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 '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