SQL for Attendance Absences | Dataford Interview Questions

Write a query to find all students who have missed more than five days of school in a specific semester for Fulton County Schools.

Use the provided student, attendance, and semester records. Treat records with an Absent status as missed days and count each calendar date once.

Output

Return one row per qualifying student.
Include student_id, first_name, last_name, and missed_days.
Include only students with more than five missed days during semester 2025-FALL.
Order by last_name, first_name, then student_id.

students

Column	Type	Description
student_idPK	INT	Unique student identifier
first_name	VARCHAR(50)	Student first name
last_name	VARCHAR(50)	Student last name
grade_level	VARCHAR(10)	Current grade level
email	VARCHAR(150)	Optional student contact email

attendance_records

Column	Type	Description
attendance_idPK	INT	Unique attendance record identifier
student_id	INT	Referenced student
semester_id	VARCHAR(20)	Referenced semester
attendance_date	DATE	Calendar date of the attendance event
status	VARCHAR(20)	Attendance status

semesters

Column	Type	Description
semester_idPK	VARCHAR(20)	Unique semester identifier
semester_name	VARCHAR(50)	Display name for the semester
start_date	DATE	First date of the semester
end_date	DATE	Last date of the semester

Your question is SQL for Attendance Absences. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.