Using Python variable substitution

Now that you've had exposure to Snowflake Notebooks, you will go a step further by performing an analysis using SQL and Python.

Your manager would like to understand how many reviews exist for Executive Resorts hotels in Mexico. They created a notebook, exercise_1_3.ipynb, located in This PC > Desktop > Resources, but didn't finish their analysis. They've asked you to take over and complete this task.

In all exercises requiring SQL queries, you will work with REVIEWS table, which is part of the HOTELS schema in the database, starting COURSE_43647.