Provide 10 other queries with their output tables for the Wine_Reviews database that are not listed below.

For each query,

-provide the SQL query code. Copy and paste the code into your Word file.

-provide the reason for the query. Why do you think the query is interesting and important to run through the dataset? Explain your reason; generic, vague arguments will not receive points.

DO NOT PROVIDE ANSWERS/QUERIES TO ANY OF THE TEN QUESTIONS BELOW (THESE ARE JUST EXAMPLES). I NEED 10 COMPLETELY DIFFERENT QUERIES.

1. List the names of tasters. Show only the distinct values.

2. What is the average price of wine by country? Show the average column as Average_Wine_Price.

3. What kinds of wine (variety) are available in Oregon?

4. Which wine (ID, country, province, and price) has the highest price?

5. How many of the reviews are by the wine taster Michael Schachner? Show the count of reviews as Review_Count.

6. List the top three wineries with the highest average review points.

7. List the first 5 records in the Wine table.

8. What are the title and review for the wine ID of 47?

9. We know that the title of a review starts with Kirkland Signature 2011 , but we do not know the rest of the title. What are the tasters name and the full title of the review that its title starts with Kirkland Signature 2011?

10. In which wineries in the province of California the average price is more than $70? Show the results in descending order by the average price.

vata uictionary: \begin{tabular}{|l|l|} \hline Title & The title of the wine review (String). \\ \hline Review_Number & The PK column unique for each wine review (String). \\ \hline Wine_ID & The PK column unique for each wine that is reviewed (Integer). \\ \hline \end{tabular} Wine Table: Review Table