SQL Subsets | Dataford Interview Questions

What are the different subsets of SQL?

Asked in the Round 3 Face to Face stage. SQL Questions. Write a query that returns the standard SQL subsets from the reference table. Rows with a NULL in is_standard are ignored.

Output

One row per standard SQL subset
Columns: subset_name, operations, and purpose
Sort by sort_order ascending

Schema

sql_subsets

Column	Type	Description
sort_orderPK	INTEGER	Canonical display order for the SQL subset
subset_name	VARCHAR(20)	Name of the SQL subset
operations	VARCHAR(255)	Representative commands associated with the subset
purpose	VARCHAR(255)	Primary purpose of the subset
is_standard	BOOLEAN	Whether the row represents a commonly recognized SQL subset

Your question is SQL Subsets. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem