Courses
Interview Courses
Product Management
Ace product interviews from strategy cases to technical skills.
Engineering Management
Review key leadership and people management skills.
Software Engineering
Learn essential strategies for coding problems and more.
System Design
Define architectures, interfaces, and databases in a time crunch.
Data Science
Execute statistical techniques and experimentation effectively.
Machine Learning
Review building, evaluating, and deploying AI/ML models.
Data Engineering
Design complex data models and ETL pipelines.
Data Analytics
New
Translate data into actionable insights and business decisions.
More Courses
TPM
Solutions Architect
UX / Product Design
Product Analytics
BizOps & Strategy
Negotiation
Engineering Behavioral
SQL Interviews
View all courses
Questions
Top Questions
Product Management
Behavioral Questions
Coding Questions
System Design
SQL Questions
Machine Learning
Data Analytics
Data Engineering
Browse all questions
Practice
Coaching
Mock Interviews & Coaching
Practice with our team of senior tech coaches.
Resume Review
Get your resume reviewed by a senior tech recruiter.
Salary Negotiation
Increase your offer with our expert negotiators.
Partners
For universities
Give your students tech interview prep.
For businesses
Improve your placement rates, outcomes, and more.
Affiliate program
Recommend us to others and earn commission.
Work with us
Help us grow the Exponent community.
Pricing
Job Referrals
Get job referrals to top tech companies.
Company Guides
Get an inside look at top companies’ interview processes.
Blog
Check out our blog on tech interviewing tips, strategies, and more.
Resources
Members-only articles, videos, and interviews.
Work with us
Help us grow the Exponent community.
Perks
Access exclusive member benefits.
Log in
Sign up
Sign up
Courses
Product Management
Ace product interviews from strategy cases to technical skills.
Engineering Management
Review key leadership and people management skills.
Software Engineering
Learn essential strategies for coding problems and more.
System Design
Define architectures, interfaces, and databases in a time crunch.
Data Science
Execute statistical techniques and experimentation effectively.
Machine Learning
Review building, evaluating, and deploying AI/ML models.
Data Engineering
Design complex data models and ETL pipelines.
Data Analytics
New
Translate data into actionable insights and business decisions.
View all courses
Questions
Product Management
Behavioral Questions
Coding Questions
System Design
SQL Questions
Machine Learning
Data Analytics
Data Engineering
Browse all questions
Practice
Coaching
Mock Interviews & Coaching
Practice with our team of senior tech coaches.
Resume Review
Get your resume reviewed by a senior tech recruiter.
Salary Negotiation
Increase your offer with our expert negotiators.
Partners
For universities
Give your students tech interview prep.
For businesses
Improve your placement rates, outcomes, and more.
Affiliate program
Recommend us to others and earn commission.
Work with us
Help us grow the Exponent community.
Pricing
More
Job Referrals
Get job referrals to top tech companies.
Company Guides
Get an inside look at top companies’ interview processes.
Blog
Check out our blog on tech interviewing tips, strategies, and more.
Resources
Members-only articles, videos, and interviews.
Work with us
Help us grow the Exponent community.
Perks
Access exclusive member benefits.
Sign up
Log in
SQL Interviews
Overview
Introduction to SQL and Its History
How to Answer SQL Interview Questions
Relationships and Relational Database Concepts
Basic SQL Querying
Basic SQL Syntax
The WHERE Clause
Logical operators: AND, OR, NOT
Finding similar results with LIKE and Wildcards
Querying Missing Values with IS NULL and IS NOT NULL
Sorting data with ORDER BY
Using LIMIT and OFFSET
IN and BETWEEN
Aggregations
Introduction to SQL Aggregations
GROUP BY and HAVING
Counting with COUNT and COUNT(DISTINCT)
SUM
Calculating Average, Min, and Max with SQL
Conditional values with CASE WHEN ... ELSE
Working with Date and Time: DATE_TRUNC, DATEDIFF, and more
Joins
Joins
Inner Joins
LEFT and RIGHT Joins
Full Outer Joins
Unions
Cross Joins
Subqueries and Derived tables
Common Table Expressions (CTEs)
Window Functions
Introduction to Window Functions
Window functions: RANK and DENSE RANK
Window functions: ROW_NUMBER
Window functions: LAG
Easy Practice Questions
Introduction to SQL Practice Questions
Top Earning Employees
Monthly Post Success Analysis
High Volume Low Success
Tree Node
Marketing Campaign Duration
Find Average Purchase Value
Survey Sampling
Items on Sale
Reddit Users
Lyft Ride Requests
E-commerce: Units Ordered Yesterday
E-commerce: Units Ordered Last Week
E-commerce: Earliest Order by Customer
Medium Practice Questions
Sales by Customer City
Most Recent Transaction
Calculate Test Scores
Project Budgets
Instagram Likes
Employee Earnings
Post Success By Interface
Post Success By Age Group
Find Campaign Purchases
Find Revenue by Department
Find Customers by Department
Find Second Highest Order
Find Conversion Rates
Find Customer Lifetime Value (LTV)
Marketing Channel Attribution
Analyze Monthly Customer Transactions
Sales Report
Monthly Sales Report
Top Customer by Orders
TV Show Watch Time
Nth Ranked Player
Number of Direct Reports
Fraudulent Transactions
EPA Temperature Monitoring
Video Game Matchmaking
Walmart Inventory Status
Unique Chat Conversations
Netflix Genre Ratings
Remove Duplicate Emails
Consecutive Logins
E-commerce: Total Orders by Category
Hard Practice Questions
Total Transaction Volume
Top Salaries by Department
Employee Hierarchy
Post Success After Failure
Find Top Customer by Year
Find Monthly Revenue Growth
Initial Contact Attribution
Ranking Salary Deviations
Game Leaderboard
Amazon Order Status
Duolingo Leaderboards
Validate Bitcoin Transactions
E-commerce: Second Earliest Order
SQL Stored Procedures
Unlock full course
SQL Interviews
Overview
Introduction to SQL and Its History
How to Answer SQL Interview Questions
Relationships and Relational Database Concepts
Basic SQL Querying
Basic SQL Syntax
The WHERE Clause
Logical operators: AND, OR, NOT
Finding similar results with LIKE and Wildcards
Querying Missing Values with IS NULL and IS NOT NULL
Sorting data with ORDER BY
Using LIMIT and OFFSET
IN and BETWEEN
Aggregations
Introduction to SQL Aggregations
GROUP BY and HAVING
Counting with COUNT and COUNT(DISTINCT)
SUM
Calculating Average, Min, and Max with SQL
Conditional values with CASE WHEN ... ELSE
Working with Date and Time: DATE_TRUNC, DATEDIFF, and more
Joins
Joins
Inner Joins
LEFT and RIGHT Joins
Full Outer Joins
Unions
Cross Joins
Subqueries and Derived tables
Common Table Expressions (CTEs)
Window Functions
Introduction to Window Functions
Window functions: RANK and DENSE RANK
Window functions: ROW_NUMBER
Window functions: LAG
Easy Practice Questions
Introduction to SQL Practice Questions
Top Earning Employees
Monthly Post Success Analysis
High Volume Low Success
Tree Node
Marketing Campaign Duration
Find Average Purchase Value
Survey Sampling
Items on Sale
Reddit Users
Lyft Ride Requests
E-commerce: Units Ordered Yesterday
E-commerce: Units Ordered Last Week
E-commerce: Earliest Order by Customer
Medium Practice Questions
Sales by Customer City
Most Recent Transaction
Calculate Test Scores
Project Budgets
Instagram Likes
Employee Earnings
Post Success By Interface
Post Success By Age Group
Find Campaign Purchases
Find Revenue by Department
Find Customers by Department
Find Second Highest Order
Find Conversion Rates
Find Customer Lifetime Value (LTV)
Marketing Channel Attribution
Analyze Monthly Customer Transactions
Sales Report
Monthly Sales Report
Top Customer by Orders
TV Show Watch Time
Nth Ranked Player
Number of Direct Reports
Fraudulent Transactions
EPA Temperature Monitoring
Video Game Matchmaking
Walmart Inventory Status
Unique Chat Conversations
Netflix Genre Ratings
Remove Duplicate Emails
Consecutive Logins
E-commerce: Total Orders by Category
Hard Practice Questions
Total Transaction Volume
Top Salaries by Department
Employee Hierarchy
Post Success After Failure
Find Top Customer by Year
Find Monthly Revenue Growth
Initial Contact Attribution
Ranking Salary Deviations
Game Leaderboard
Amazon Order Status
Duolingo Leaderboards
Validate Bitcoin Transactions
E-commerce: Second Earliest Order
SQL Stored Procedures
Unlock full course