Why Snowflake SQL extends standard SQL - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select all columns from a table named 'employees'.

Snowflake

SELECT [1] FROM employees;

Drag options to blanks, or click blank then click option'

A*

BALL

CEVERY

DCOLUMNS

Attempts:

3 left

💡 Hint

Common Mistakes

Using words like ALL or COLUMNS instead of *.

In SQL, * means select all columns from the table.

2fill in blank

medium

Complete the code to create a Snowflake stage named 'mystage'.

Snowflake

CREATE STAGE [1];

Drag options to blanks, or click blank then click option'

Amy_stage

Bstage1

Cmystage

Dstage_1

Attempts:

3 left

💡 Hint

Common Mistakes

Adding underscores or numbers not in the name.

Snowflake stage names are identifiers. Here, 'mystage' is the correct name as per instruction.

3fill in blank

hard

Fix the error in the Snowflake SQL command to create a table with a column 'id' as integer.

Snowflake

CREATE TABLE users (id [1]);

Drag options to blanks, or click blank then click option'

ASTRING

BINTEGER

CTEXT

DVARCHAR

Attempts:

3 left

💡 Hint

Common Mistakes

Using string types instead of integer.

The correct data type for an integer column in Snowflake is INTEGER.

4fill in blank

hard

Fill both blanks to create a Snowflake SQL query that selects the count of rows from 'orders' where 'status' equals 'shipped'.

Snowflake

SELECT COUNT([1]) FROM orders WHERE status [2] 'shipped';

Drag options to blanks, or click blank then click option'

A*

B=

C!=

Dorder_id

Attempts:

3 left

💡 Hint

Common Mistakes

Using != instead of = for filtering.

Use * to count all rows and = to filter where status equals 'shipped'.

5fill in blank

hard

Fill all three blanks to create a Snowflake SQL query that selects the upper case of 'name', the 'age', and filters where 'age' is greater than 30.

Snowflake

SELECT [1](name), [2] FROM people WHERE age [3] 30;

Drag options to blanks, or click blank then click option'

AUPPER

Bage

C>

DLOWER

Attempts:

3 left

💡 Hint

Common Mistakes

Using LOWER instead of UPPER.

Using < instead of >.

Use UPPER to convert name to uppercase, select age, and filter with > for ages greater than 30.