total_assistance_requests_for.sql

SELECT name, count(*) AS total_assistances
FROM students
JOIN assistance_requests ON student_id = students.id
WHERE students.name = 'Elliot Dickinson'
GROUP BY students.name