How many of the reviews are by the wine taster Jim Gordon? Show the count of reviews as review_count.

PLEASE USE SQL WORKBENCH last name: Levi first name: Veronika
In a Word file nswer the following questions using SQL query codes. After each question, provide your SQL query and the screenshot of the output table. Name your submission file as LastNameFirstName_ICA2_part1

List the names of the tasters. Show only the distinct values.
What is the average price of the wine by country? Show the average column as average_wine_price.
What kinds of wine (variety) are available in Oregon?
Which wine (ID, country, province, and the price) has the highest price?
How many of the reviews are by the wine taster Jim Gordon? Show the count of reviews as review_count.
List the top three wineries with the highest average review points.
List the top 5 records in the wine table.
What are the title and review for the wine ID of 342.
We know that the title of a review starts with Tommasi 2001 …, but we do not know the rest of the title. What is the taster’s name and full title of the review that its title starts with Tommasi 2001?
In which wineries in the province of California the average price is more than 100? Show the results in descending order by the average price.

Last Completed Projects