Real questions from top companies in SQL
Query Optimization Strategies
Query Performance in Redshift - optimization
Query for 2nd Latest Joining Per Department
Query to Print Match List Against Every Team
REPARTITION vs COALESCE for managing partitions
Rank, Dense Rank, and Row Number - Differences
Real-Time Scenarios with Stored Procedures
Remove duplicates, fill missing values, and apply schema validation using ScalaSpark
Removing duplicates - ROW_NUMBER() or DISTINCT
Replace each node's value with the next greater value in the list. Addressed edge cases where no greater element exists.
Retrieve Schema of BigQuery Table
Review Kafka fundamentals and concepts.
SCD Implementation in ETL
SCDs: Types of Slowly Changing Dimensions and their use cases
SELF JOIN Applications - scenarios like manager-employee relationships
SQL Case study involving bank liabilities, loans, and balances - extensive JOINs and CASE statements
SQL Cross Join - difficult question
SQL Problem - multiple table joins and window functions
SQL Query Design: employees with highest salaries within each department
SQL Query Optimization techniques
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.