USING THE GRAPHS IN THE SECOND PICTURE, PROVIDE SQL QUERIES BY ANSWERING THE QUESTIONS IN THE FIRST PICTURE:

$8.$ Display the total sales for each state from the sale and customer tables, where the total sales more than $1000,$ and sorts the results in descending order based on the total sales.

Here is a partial output

$9.$ List all the information in the sales table, plus the productname, category, and color for sales of green sneakers and green sandals.

$10.$ Create a customer view from customer table that includes customer id$,$ first name, customer last name and customer phone. Display the results of the customer view.