Answer:
SELECT StudentFullname FROM Studentdata INNER JOIN Student_Class ON Studentdata.uniqueno = Student_Class.student_id LEFT JOIN Student_Instructor ON Student_Class.instructor_id = Student_Instructor.id WHERE Student_Instructor.faculty <> 'Computer Science'
Explanation:
Assume the following table names;
Studentdata - for student table
Student_Class - for each class
Student_Instructor - for student's instructors
The code first list out StudentFullname from studentdata table.
The code is the connected to Student_Class to get a list of students in class
The code is then connected to Student_Instructor table to get a list of instructors in class
Lastly, the where then filters instructors that are not from computer science department
Computer hardware is any physical device used in or with your machine, whereas software is a collection of code installed onto your computer's hard drive. For example, the computer monitor you are using to read this text and the mouse you are using to navigate this web page is computer hardware.
Essentially, computer software controls computer hardware. These two components are complementary and cannot act independently of one another. In order for a computer to effectively manipulate data and produce useful output, its hardware and software must work together.
