Question

1. Write and run the SQL to list the ClassID, ClassDescription, ClassroomID, BuildingName  and Capacity for all classes, using the inner join [matching on ClassroomID] to extract variables from the BSU_Class and BSU_Classrooms tables.

Sort the output in ascending sequence by ClassID and Building name

Answer 1

This query will return the list of the ClassID, ClassDescription, ClassroomID, BuildingName  and Capacity for all classes, using the inner join:

SELECT BSU_Class.ClassID, BSU_Class.ClassDescription, BSU_Class.ClassroomID, BSU_Classrooms tables.BuildingName, BSU_Class.Capacity

FROM BSU_Class

INNER JOIN BSU_Class ON  BSU_Class.ClassroomID =  BSU_Classrooms tables.ClassroomID

ORDER BY BSU_Class.ClassroomID ASC ,  BSU_Classrooms tables.ClassroomID ASC;