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?
Deze oefening maakt deel uit van de cursus
Introduction to Snowflake SQL
Oefeninstructies
- Select
pizza_type_id,pizza_size, andpricefrom thepizzastable.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Select pizza_type_id, pizza_size, and price from pizzas table
___ ___,
___,
___
FROM ____