Real questions from top companies in SQL
Write an SQL query to find duplicate emails in a users table.
Triggers in ADF, especially tumbling window triggers.
What is a CTE (Common Table Expression)? What are its uses?
What is a window function? Explain with an example.
What is the difference between OLTP and OLAP?
Write a SQL query to find top 3 earners in each department.
Write a query to find the top three highest-paid employees in each department using window functions.
Write complex SQL queries involving multiple joins, subqueries, and data aggregation logic.
Add Row Numbers using window function in PySpark
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.
Aggregate surface areas and calculate cumulative surface area using the LAG function.
Are you comfortable with the variable pay structure, and what are your expectations for the base salary?
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?
Cloud Architecture - explain
Compare Airflow's @daily vs once trigger scheduling.
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.