Quiz: Advanced SQL Tutorial | Subqueries

Test your knowledge on key concepts from this video.

1. Subqueries are often called inner queries or ______ queries.

• Click to reveal answer

2. A subquery is basically a ______ within a query.

• Click to reveal answer

3. A subquery is used to return data that will be used in the ______ query.

• Click to reveal answer

4. Subqueries can be used in the select, from, where, insert, update, and ______ statements.

• Click to reveal answer

5. When using a subquery in the WHERE statement, the inner query can only return ______ column.

• Click to reveal answer

6. When creating a table-like result, CTEs or ______ tables are generally preferred over subqueries in the FROM clause for efficiency.

• Click to reveal answer