Expect SQL queries based on Joins, Aggregations, Subqueries, CTEs, and Window functions
Common tasks include:
Writing queries to filter, group, and transform data
Joining multiple tables to extract insights
Identifying duplicates, NULL values, and performing data cleansing
Using CASE WHEN, COALESCE, RANK(), and PARTITION BY
