Search⌘ K
AI Features
Home
Courses
Learn SQL

Solution: Go Multi-Level

Explore how to write SQL queries that join multiple tables to find students scoring over 85 in any subject. Learn to combine tables, apply filters, and sort results to analyze real-world datasets effectively.

We'll cover the following...

Query

SELECT s.name, g.subject, g.score
FROM students s
JOIN grades g ON s.id = g.student_id
WHERE g.score > 85
ORDER BY g.score DESC;

Explanation

This query lists the names of students who scored above 85 in any ...