/* Display all courses */

select * from course; 


/* Display all students and their info */

select * from student; 
select * from student_info;


/* Display all instructors and their info */

select * from instructor; 
select * from instructor_info; 


/* Display entire school roster */

select * from roster;


/* Display all instructors and their students             */
/* As well as all students who are not taking any classes */ 

select inst_fname, inst_lname, course_id, description, stu_fname, stu_lname
from roster 
where stu_lname  is not null
   or inst_lname is not null
order by 2 desc, 3