1280. Students and Examinations

https://leetcode.com/problems/students-and-examinations

Description

Table: Students

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| student\_id    | int     |
| student\_name  | varchar |
+---------------+---------+
student\_id is the primary key for this table.
Each row of this table contains the ID and the name of one student in the school.

Table: Subjects

+--------------+---------+
| Column Name  | Type    |
+--------------+---------+
| subject\_name | varchar |
+--------------+---------+
subject\_name is the primary key for this table.
Each row of this table contains the name of one subject in the school.

Table: Examinations

Write an SQL query to find the number of times each student attended each exam.

Order the result table by student_id and subject_name.

The query result format is in the following example:

ac

Previous1279. Traffic Light Controlled IntersectionNext1281. Subtract the Product and Sum of Digits of an Integer

Last updated

Was this helpful?