Interview Questions

SQL Cross Join - difficult question

SQL Problem - multiple table joins and window functions

SQL Query for 2nd Highest Salary without Using MAX()

SQL Query for Best of 3 Marks and Average in a Student Table

SQL Query to Find Average Sessions per User within 30-day period

SQL Question - Cricket Scoreboard Table - aggregations, joins, grouping

SQL Question - Inner Join with Null Handling, compute total row count

SQL query with LAG function.

SQL questions: Group By, Joins, Correlated Queries

Self-joins to compare employee salaries?

Simulate a producer-consumer model using multithreading.

Solve a coding question related to window functions using SQL and PySpark.

Solve a problem using a window function in Spark or SQL.

Solve a query using window functions and GROUP BY to rank or aggregate data.

Solve a running sum query

Solve medium-level SQL questions involving two tables with null values - LEFT JOIN, RIGHT JOIN, INNER JOIN

Teradata to Hadoop migration and handling data with SCD Type 2?

Test SQL skills using advanced window functions such as LAG, LEAD, and DENSE_RANK.

Two tables: Table 1 has 8 records, Table 2 has 2 records, common column id. How many records would result with Inner Join, Left Join, Right Join, Full Outer Join?

What are BigQuery Slots?