• SQLPad
  • Questions Course Pricing Resources Career AI NEW
  • Sign In
  • Close

    Pages

    SQL Questions About Course Leaderboard Tutorials Contact Forum Job Mentor FAQs
    Sign In

SQL Coding Questions by Industry

Advertising Ai Ecommerce Education Fintech Food Delivery Forum Gaming Hospitality Human Resource Mobile Music Search Engine Social Subscription Video Streaming

SQL Coding Questions by SQL Operations

Single table operations

SELECT, WHERE, AND, OR, ORDER BY, LIMIT

COUNT, SUM, AVERAGE, MIN, MAX, GROUP BY, HAVING

IN, BETWEEN, LIKE, CASE WHEN

Multi-table operations

INNER JOIN

OUTER JOIN

UNION, UNION ALL

WINDOW functions

AVG, SUM, MAX/MIN

ROW_NUMBER, RANK, DENSE_RANK

NTILE

LAG, LEAD

Try a random SQL Question SQL Playground
About Blog For Business Forum Contact FAQ Product News Leaderboard

SQLPad Monthly Plans

Practice 216 SQL Questions Online

Course (included in the Premium plan)

Cracking the SQL Interview for Data Professionals


MENTORING SERVICES on instamentor.com ™️

📞 SQL Mock Interview 📖 Resume Feedback 👨🏻‍⚕️ Career Consulting 🏛 Career Accelerator

SQL Coding Questions & Answers

Practice 216 online coding questions and become a SQL expert.

ALL QUESTIONS

Advertising Ai Ecommerce Education Fintech Food Delivery Forum Gaming Hospitality Human Resource Mobile Music Search Engine Social Subscription Video Streaming

Multi-Table Operation: Lecture 2: OUTER JOINS


ID Title Level FTPR Lecture
41 Productive actors vs less-productive actors hard
6%
3.2
42 Films that are in stock vs not in stock medium
11%
3.2
43 Customers who rented vs. those who did not medium
9%
3.2
44 In-demand vs not-in-demand movies medium
6%
3.2
45 Movie inventory optimization hard
7%
3.2
51 Movie only actor easy
43%
3.2
52 Movies cast by movie only actors hard
13%
3.2
53 Movie groups by rental income hard
11%
3.2
54 Customer groups by movie rental spend medium
21%
3.2
55 Busy days and slow days medium
11%
3.2
56 Total number of actors easy
32%
3.2
100 Advertiser ROI advertising medium
9%
3.2
118 Daily bookings in the US hospitality hard
5%
3.2
140 Daily sales of restaurant 100011 food delivery hard
9%
3.2
168 Average number of streams in the US video streaming medium
13%
3.2
172 Comments distribution social hard
13%
3.2
191 Number of replies by group social medium
100%
3.2
194 Daily active users report for new market social easy - 3.2
213 Interchange revenue by issuer and merchant category fintech easy - 3.2
  • Previous
  • 1(current)
  • Next

Владислав

Solved problem 95

56 minutes ago

Verified by SQLPad

Amy

Solved problem 41

51 minutes ago

Verified by SQLPad

Владислав

Solved problem 94

1 hour, 17 minutes ago

Verified by SQLPad

Amy

Solved problem 40

1 hour, 7 minutes ago

Verified by SQLPad

akhila

Attempted problem 14

57 minutes ago

Verified by SQLPad

Amy

Solved problem 39

1 hour, 12 minutes ago

Verified by SQLPad

Amy

Attempted problem 43

28 minutes ago

Verified by SQLPad

Владислав

Solved problem 96

43 minutes ago

Verified by SQLPad

Владислав

Solved problem 97

32 minutes ago

Verified by SQLPad

Amy

Solved problem 42

41 minutes ago

Verified by SQLPad


SQLPad | Ace Your Next SQL Interview

SQLPad is an online SQL playground with 216 SQL coding questions and a video course to learn, practice and refresh your SQL skills.

Resources

About Pricing Contact News FAQ

Comparisons

Leetcode HackerRank Mode

Resources

📞 Mock Interview 📖 Resume Feedback 👨🏻‍⚕️ Career Coaching 💰 Salary Negotiation 👩‍💻 Posture App 🗞 leonwei.com Reddit Monitoring

Legal

Privacy
Terms of Service

2022 SQLPad ™️, All Rights Reserved