Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
14. School Top Achievers by Subject (Hard)
On this page

Problem Statement

Table: Student
Each row in this table represents a student's performance in a specific subject, including their unique ID, name, score, and the subject ID they were evaluated in.

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| id          | int     |
| name        | varchar |
| score       | int     |
| subjectId   | int     |
+-------------+---------+
id is the primary key for this table.
subjectId is a foreign key referencing the id from the Subject table.

Table: Subject

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page