Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
29. High School Attendance
On this page

Problem

Table: Students

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| student_id    | int     |
| student_name  | varchar |
| grade         | int     |
+---------------+---------+
student_id is the primary key for this table.
This table contains the information of students in a high school.

Table: Attendance

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| student_id    | int     |
| attendance_date | date  |
| status        | enum    |
+---------------+---------+

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page