Subqueries in FROM clause

SELECT    
FROM      (
                
          ) 
          JOIN
          (
        
          )
ON        
GROUP BY
ORDER BY


SELECT    booksSummary.course AS course,
          booksSummary.numberOfBooks AS numberOfBooks,
          studentsSummary.numberOfStudents AS numberOfStudents
FROM      (
                SELECT   courses.id AS courseId,
                         courses.name AS course,
                         COUNT(books.id) AS numberOfBooks
                FROM     courses LEFT JOIN books
                ON       books.courseId = courses.id
                GROUP BY courses.id
          ) AS booksSummary
          JOIN
          (
                SELECT   courses.id AS courseId,
                         COUNT(students.id) AS numberOfStudents
                FROM     courses LEFT JOIN students
                ON       students.courseId = courses.id
                GROUP BY courses.id
          ) AS studentsSummary
ON        booksSummary.courseId = studentsSummary.courseId
GROUP BY  course
ORDER BY  course
