1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Snowflake SQL
Connected

Exercise

Querying JSON data

Yelpto, a leading platform for discovering local businesses, seeks your expertise as a consulting Data Engineer.

They aim to explore the restaurant industry, focusing on popular 5-star-rated restaurants that are open on weekends in Philadelphia.

You'll work with the yelp_business_data table, particularly the name, categories, attributes, and hours columns.

You can explore the yelp_business_data table in the SQL console.

SQL console

Note that the attributes and hours columns are VARIANT types.

Instructions

100 XP
  • Retrieve Saturday hours from the hours VARIANT column.
  • Retrieve Sunday hours from the hours VARIANT column.
  • Filter where categories include 'Restaurant'.
Powered by Snowflake