JavaScript is required to use this application. Please enable JavaScript in your browser settings or disable any extensions that may be blocking scripts.
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?
Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.