• 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 1: AVG, MIN/MAX, SUM


ID Title Level FTPR Lecture
58 Percentage of revenue per movie hard
8%
4.1
59 Percentage of revenue per movie by category medium
7%
4.1
60 Movie rentals and average rentals in the same category hard
9%
4.1
61 Customer spend vs average spend in the same store hard
12%
4.1
70 Cumulative spend easy
14%
4.1
71 Cumulative rentals easy
18%
4.1
108 Free premium membership ecommerce hard
17%
4.1
113 Daily cumulative spend ecommerce easy
9%
4.1
115 Rolling average revenue ecommerce hard
26%
4.1
117 Rolling 7 days total answers ai easy
35%
4.1
141 Cumulative sales of restaurant 100011 food delivery hard
16%
4.1
182 Top 5 content by number of watchers video streaming medium
4%
4.1
189 Campaign activation date advertising medium
0%
4.1
  • Previous
  • 1(current)
  • Next

Amy

Solved problem 41

12 minutes ago

Verified by SQLPad

Владислав

Attempted problem 97

0 minutes ago

Verified by SQLPad

akhila

Attempted problem 14

18 minutes ago

Verified by SQLPad

Владислав

Solved problem 95

17 minutes ago

Verified by SQLPad

Владислав

Solved problem 94

39 minutes ago

Verified by SQLPad

Владислав

Solved problem 96

5 minutes ago

Verified by SQLPad

Amy

Solved problem 39

34 minutes ago

Verified by SQLPad

Владислав

Solved problem 93

44 minutes ago

Verified by SQLPad

Amy

Solved problem 40

29 minutes ago

Verified by SQLPad

Amy

Solved problem 42

3 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