Real questions from top companies in SQL
Finding nth Highest Salary within each department
Given a CSV file with raw customer transactions, design an ETL pipeline that cleans data, aggregates total sales by region and product, and loads into target table
Given a dataset, perform transformations: Filter rows where sales > 1000, Add a new column calculating a 10% discount on sales, Group data by region and calculate total revenue.
Given a table with 10 records and another with 4 records, how many records result from a cross join?
Given two dataframes (df1: id, name and df2: id, country, address, city, count), join them, filter for rows where country = 'Singapore', and pivot the output. Sort cities in descending order of population count
How can you automate data insertion into BigQuery using Python?
How can you delete partitions from a table in Hive using a command?
How do you count occurrences in a column in SQL?
How do you design a scalable and fault-tolerant data warehouse on a cloud platform?
How do you interact with Google BigQuery using Python?
How do you keep a specific column on top in SQL?
How many records result from Inner Join, Left Join, Right Join given Table A and Table B?
How many rows result from left, right, full outer, and inner joins?
How to Handle Null in Spark
How to Use Dataflow with BigQuery
How to optimize join of large and small tables in Spark?
How to view Oozie jobs?
How would you clean the data by filtering out records with null values in user_id?
How would you deal with data skewness in a large dataset?
How would you design a data model for an e-commerce platform?
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.