SQL Guide to Yelp Database (Final Assignment of “SQL for Data Science”)

This article will guide you on how to answer the final assignment* of SQL for Data Science, a course created by the University of California-Davis and offered by Coursera. I highly recommend the course if you want to have a certificate on and learn about SQL coding syntax. The final assignment accesses the Yelp dataset and provides a worksheet of questions that test your SQL skills.

Once completed, the worksheet is uploaded for peer grading. If you are not taking the course and are just interested in practicing SQL querying, you can still learn from this guide. Lastly, do not use this guide to cheat on the final assignment. I want you to understand how to answer the questions, not copy the answers and codes.

*The name of the final assignment is Data Scientist Role Play: Profiling and Analyzing the Yelp Dataset.

Where will I code?

The course is based on SQLite and provides a Lab Sandbox (within the Coursera platform) where you can code and access the Chinook database, which is the reference material of the course from Week 1 to Week 4. But in the final assignment, a separate page for Yelp Dataset SQL Lookup is provided. (No installation required.) Because it is already connected to the database, this is where I am going to code.