Querying using Snowflake SQL
You are consulting as a Data Engineer at Pissa, an expanding pizza delivery company. Their database has four tables: pizzas, pizza_types, orders, and order_details. You can view each table from the SQL console:
As part of their transition from PostgreSQL to Snowflake, you're now examining the different columns in the pizzas table. Are you ready to refresh your SQL skills?
This exercise is part of the course
Introduction to Snowflake SQL
Exercise instructions
- Select
pizza_type_id,pizza_size, andpricefrom thepizzastable.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Select pizza_type_id, pizza_size, and price from pizzas table
___ ___,
___,
___
FROM ____