Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

14. School Top Achievers by Subject (Hard)
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

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!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible