SQL quizzes and my solutions

Project Prep Questions

• Uses a combination of all SQL command.

Advance Joins

• Uses Advance JOINS: SELF JOINS and UNION.

Window functions

• Uses Window functions: OVER, PARTITION BY, ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD and NTILE.

CTEs and Subqueries

• Uses Subqueries and WITH. statement

Aggregations

• Uses SUM, AVG, MIN, MAX, COUNT, NULLs, DISTINCT, HAVING, DATE_TRUNC, DATE_PART and CASE view queries.

Joins

• Uses JOINS.