Filtering in Snowflake SQL
As part of Pissa's migration from PostgreSQL to Snowflake, ensuring data integrity and correctness of the data after migration is crucial.
You're specifically working with the pizza_type table, which contains the following columns: pizza_type_id, name, category, and ingredients.
Let's apply your SQL skills to Snowflake!
This exercise is part of the course
Introduction to Snowflake SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Count all pizza entries
SELECT ___(___) AS count_all_pizzas
FROM pizza_type