• 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

Window Functions: Lecture 4: LAG, LEAD


ID Title Level FTPR Lecture
68 Spend difference between first and second rentals hard
12%
4.4
69 Number of happy customers hard
12%
4.4
79 Spend difference between the last and the second last rentals hard
18%
4.4
80 DoD revenue growth for each store hard
19%
4.4
114 Dod revenue change rate ecommerce easy
13%
4.4
121 Week over week change of first ever bookings hospitality hard
6%
4.4
147 2 days streak customers social hard
11%
4.4
180 Members moved from Microsoft to Google directly. human resource hard
16%
4.4
195 MoM user growth social hard - 4.4
199 Students improvement education hard - 4.4
  • Previous
  • 1(current)
  • Next

Amy

Solved problem 39

1 hour, 1 minute ago

Verified by SQLPad

Владислав

Solved problem 96

33 minutes ago

Verified by SQLPad

Владислав

Solved problem 95

45 minutes ago

Verified by SQLPad

Amy

Solved problem 40

56 minutes ago

Verified by SQLPad

Amy

Solved problem 41

40 minutes ago

Verified by SQLPad

Владислав

Solved problem 97

21 minutes ago

Verified by SQLPad

Amy

Attempted problem 43

18 minutes ago

Verified by SQLPad

Amy

Solved problem 42

30 minutes ago

Verified by SQLPad

akhila

Attempted problem 14

46 minutes ago

Verified by SQLPad

Владислав

Solved problem 94

1 hour, 7 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