Restaurant Ratings in SQL

This is my first project exploring the vast capabilities of SQL and Microsoft SSMS. To start, I chose the Restaurant Ratings dataset from the Maven Data Playground and downloaded the Excel files. Then, I loaded the 5 tables into Microsoft SSMS by creating identical table structures and copy/pasting the data over.

The goal of this project was to answer 5 questions about the data that I devised based on examining the data information and the fields available. Here are the questions and the SQL skills required to come up with answers for them.

1. Do consumers who smoke give higher ratings to restaurants that allow smoking? Do consumers who do not smoke give lower ratings to restaurants that allow smoking?

SKILLS: GROUP BY, subqueries, JOIN, AVG(), COUNT()

2. What percentage of consumers ate at a restaurant that served their preferred cuisine?

SKILLS: data type conversion, SUM(), JOIN, FORMAT(), subquery

3. What were the top 3 highest scoring cuisine types? Bottom 3?(min 10 reviews)

SKILLS: GROUP BY, HAVING, ORDER BY, TOP(), JOIN

4. Did any consumers with a low budget score a high costing restaurant well (2)?

SKILLS: JOIN, WHERE

5. What age group(by decade) gave the highest average rating for service? Is it substantially greater than other age groups?

SKILLS: CASE WHEN, JOIN, GROUP BY, subquery

While relatively elementary, these skills showcase the power of what SQL can accomplish in data, and how valuable insights can be extracted using it.