Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

29. High School Attendance
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

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!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible