SQL Interview Questions - Top SQL Interview Problems

“Keep showing up. That's where the magic happens.”

— GrindGram

View full list(136 problems)

Basic Information & Schema· 15

Introduction & Prerequisites

Introduction
Prerequisites

College Database Schema

Students Table Data
Table 2: professors
Professors Table Data
Table 3: courses
Courses Table Data
Table 4: enrollments
Table 5: examinations
Your go-to sheet for mastering all the common SQL query patterns used in technical interviews.
Scenario: Your College Database
4 Simple Tables (Easy to Understand!)
Table 1: students
Enrollments Table Data
Examinations Table Data

SQL Fundamentals - SELECT, WHERE, ORDER BY· 21

Top CSE Performers

Question
Solution
Result

Veteran Faculty Search

Result
Solution
Question

Credit Power Rankings

Question
Solution
Result

Professor's Course Catalog

Question
Solution
Result

Fresh Recruits

Question
Solution
Result

Elite Student League

Question
Solution
Result

Department Diversity Check

Question
Solution
Result

SQL Sorting & Grouping· 12

Find Unique Subjects Per Student

Problem
Solution
Result

Students with Recent Exams

Problem
Solution
Result

First Exam Per Student

Problem
Solution
Result

Students Per Professor

Problem
Solution
Result

Aggregate Functions· 24

Find Average CGPA of All Students

Problem
Result
Solution

Find Students with Odd ID in CSE Department

Problem
Result
Solution

Find Highest CGPA Among ME Students

Problem
Result
Solution

Count Students by Department

Problem
Result
Solution

Average Exam Duration by Course

Problem
Result
Solution

Average Professor Experience by Department

Problem
Result
Solution

Course Registration Percentage

Problem
Result
Solution

Monthly Exam Statistics by Department

Problem
Result
Solution

Joins (INNER, LEFT, RIGHT)· 24

Student Course Roster

Question
Solution
Result

Unregistered Students

Question
Solution
Result

Busy Professors

Question
Solution
Result

Orphaned Courses

Question
Solution
Result

Above Average Scholars

Question
Solution
Result

Attendance Tracker

Question
Solution
Result

Exam Duration Calculator

Question
Solution
Result

Professor Impact Score

Question
Solution
Result

Advanced Queries· 22

The Professor Report Challenge

Problem Context
Task
Requirements
Output
Solution
Result

Student Primary Department

Problem Context
Logic
Rules
Task
Solution
Result

The 1000-Minute Exam Budget

Problem Context
Task
Notes
Solution
Result

Consecutive Grade Pattern

Problem
Important
Output
Solution
Result

Subqueries & Nested Logic· 18

Students Above Department Average

Problem Statement
Solution
Result

Courses Not Taken by Any Delhi Student

Problem Statement
Solution
Result

Enrolled in All Courses by Dr. Meera

Problem Statement
Solution
Result

Department With Highest Average Attendance

Problem Statement
Solution
Result

Course with Highest Average Attendance in Fall 2024

Problem Statement
Solution
Result

Students with Most Classmates

Problem Statement
Solution
Result