SELECT items.name AS item_name, categories.name AS category_name FROM items INNER JOIN item_categories ON item_categories.item_id = items.id INNER JOIN categories ON item_categories.category_id = categories.id WHERE items.name='arugula salad';
SELECT students.name AS student, classes.name AS class FROM students INNER JOIN enrollments ON enrollments.student_id = students.id INNER JOIN classes ON classes.id = enrollments.class_id;
SELECT students.name AS name, enrollments.grade AS grade FROM students INNER JOIN enrollments on enrollments.student_id = students.id;
SELECT students.name AS name, AVG(enrollments.grade) AS grade FROM students INNER JOIN enrollments on enrollments.student_id = students.id GROUP BY students.name;
SELECT students.name AS name, COUNT(enrollments.class_id) AS classes FROM students INNER JOIN enrollments on enrollments.student_id = students.id GROUP BY students.name;
SELECT students.name AS name, COUNT(enrollments.class_id) AS class_count FROM students INNER JOIN enrollments on enrollments.student_id = students.id GROUP BY students.name HAVING COUNT(enrollments.class_id) > 2;
SELECT students.name AS student_name, teachers.name AS teacher_name, classes.name AS class_name FROM students INNER JOIN enrollments ON enrollments.student_id = students.id INNER JOIN classes ON classes.id = enrollments.class_id INNER JOIN teachers ON teachers.id = classes.teacher_id;
SELECT students.name AS student_name, teachers.name AS teacher_name, classes.name AS class_name FROM students INNER JOIN enrollments ON enrollments.student_id = students.id INNER JOIN classes ON classes.id = enrollments.class_id INNER JOIN teachers ON teachers.id = classes.teacher_id GROUP BY student_name, teacher_name, class_name;
SELECT classes.name, AVG(enrollments.grade) FROM classes INNER JOIN enrollments ON enrollments.class_id = classes.id GROUP BY classes.name;
SELECT students.name AS student_name, enrollments.grade AS grade, classes.name AS class_name FROM students INNER JOIN enrollments ON enrollments.student_id = students.id INNER JOIN classes ON classes.id = enrollments.class_id WHERE grade < (SELECT AVG(enrollments.grade) FROM enrollments INNER JOIN classes on classes.id = enrollments.class_id);