Real questions from top companies
Add a column to the Employees table that shows the name of the employee with the next higher employee_id.
Add a new column with manager names for each employee using a self-join.
Add a new column with the average salary by department.
Advanced SQL with CTEs and Conditional Joins
Aggregate surface areas and calculate cumulative surface area using the LAG function.
Analyze the output of various joins (LEFT, RIGHT, INNER, CROSS, FULL OUTER) on the given tables.
Are you comfortable with the variable pay structure, and what are your expectations for the base salary?
Building ETL pipelines to capture changes when new records are inserted into source tables?
CSV Without Column Names/Schema - how to read
Calculate the cumulative transaction amount for each month using a transaction table.
Can CASE statements be used in an UPDATE query?
Can you chain multiple triggers for a single pipeline?
Can you describe a project where you handled large volumes of data?
Can you modify a partitioned table into a non-partitioned one and vice-versa? How?
Can you provide a use case where Assert Transformations helped maintain data quality?
Can you share an experience where you resolved a conflict within your team?
Case statement in SQL - explain
Check for duplicates in a table.
Cloud Architecture - explain
Coalesce function in SQL - explain
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.