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?
Questo esercizio fa parte del corso
Introduction to Snowflake SQL
Istruzioni dell'esercizio
- Select
pizza_type_id,pizza_size, andpricefrom thepizzastable.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Select pizza_type_id, pizza_size, and price from pizzas table
___ ___,
___,
___
FROM ____