Coding time

Report a typo

Rewrite the query to see it's execution time.

SELECT AVG(s.mark) as mark,
       s.faculty_name
FROM (SELECT f.name as faculty_name,
             m.mark
      FROM mark m
      INNER JOIN students s on s.id = m.student_id
      INNER JOIN (SELECT id,
                         name
                  FROM faculty_name
          ) f ON f.id = s.faculty_id) as s
WHERE s.faculty_name = 'Ravenclaw'
GROUP BY s.faculty_name;

Write an SQL statement





Create a free account to access the full topic