Assessment

SQL Skill Test

Prove your SQL skills in a timed, real-world assessment

⏱30 Minutes
📝15 Questions
💯Pass at 75/100
🔁Retake Anytime
10 SQL Writing Questions8 pts each
5 Multiple Choice Questions4 pts each
Total100 points
Before you begin
  • You have exactly 30 minutes. The timer starts when you click "Start Test".
  • The test uses an isolated sandbox: employees and departments tables (described inside the test).
  • SQL questions are auto-evaluated against expected output — column order and row order matter where stated.
  • You can run queries during the test to preview results. Results are not graded until you submit.
  • You can retake the test as many times as you like — your most recent result is always shown.

You need to be logged in to take the test.

EASY · BEGINNER FRIENDLY
SQL Window Functions Easy Challenge
10 challenges · ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD & more · 20 min
→
MEDIUM · INTERVIEW PRACTICE
SQL Window Functions Medium Challenge
15 challenges · ROW_NUMBER, RANK, DENSE_RANK, PARTITION BY & more · 30 min
→
ADVANCED · PREMIUM
SQL Window Functions Hard Challenge
20 advanced challenges · ROW_NUMBER, RANK, LAG, LEAD & more · 45 min
→
MEDIUM · INTERVIEW PRACTICE
SQL LEFT JOIN Medium Challenge
15 challenges · LEFT JOIN, IS NULL, missing records & NULL handling · 30 min
→
NEW · HARD · INTERVIEW SIMULATION
SQL LEFT JOIN Hard Challenge
20 advanced challenges · missing records, NULL handling, revenue & churn analysis · 45 min
→

Why Take the SQL Skill Test?

The SQL Skill Test is a timed, real-world SQL assessment built to mirror the SQL interview rounds used at tech companies, data teams, and analytics engineering roles. Unlike multiple-choice quizzes, 10 of the 15 questions require you to write real SQL that is evaluated against expected query output — exactly how a technical take-home challenge works. You get a scored result and a shareable certificate the moment you submit.

Whether you are preparing for a data analyst interview, a business intelligence role, or a backend engineering position, this test gives you an honest benchmark of your current SQL level and a credential you can link from your LinkedIn profile or resume.

SQL Topics Covered in the Test

Core SQL (Easy–Medium)

  • SELECT, WHERE, ORDER BY, LIMIT
  • GROUP BY, HAVING, COUNT, SUM, AVG
  • INNER JOIN and LEFT JOIN
  • Subqueries and CASE WHEN

Advanced SQL (Medium–Hard)

  • Window functions: ROW_NUMBER, RANK, LAG
  • Common Table Expressions (CTEs)
  • Multi-table analytical queries
  • Running totals and ranking patterns

How Scoring Works

Each SQL writing question is worth 8 points. Each multiple-choice question is worth 4 points. The total is 100 points. The passing threshold is 75 / 100. SQL answers are evaluated automatically — your query output is compared to the expected result set, so there is no manual grading delay. You see your score the instant you submit.

Candidates who pass receive a shareable certificate showing their score, the number of questions answered correctly, and the completion date. The certificate link is unique per candidate and can be shared on LinkedIn, added to a resume, or included in a job application.

How to Prepare

The best preparation is writing real SQL queries against real data. Use the SQL Practice Challenges to work through problems at Easy, Medium, and Hard difficulty — focusing especially on JOINs, GROUP BY patterns, and window functions, which appear most frequently in the test.

The SQL Playground lets you run free-form queries against the same e-commerce database used throughout the platform. Read the SQL Blog for guides on window functions, CTEs, and SQL interview preparation strategies.