Home /
Expert Answers /
Computer Science /
the-table-relation-name-is-instructor-1-specify-a-sql-query-to-find-the-names-of-all-the-instruct-pa391
(Solved): THE TABLE/RELATION NAME IS INSTRUCTOR 1. Specify a SQL query to find the names of all the instruct ...
THE TABLE/RELATION NAME IS INSTRUCTOR 1. Specify a SQL query to find the names of all the instructors from Biology department 2. Specify a SQL query to find the names of courses in Computer Science ('Comp.Sci.') department which have 3 credits 3. Specify a SQL query to find all course_id and title of all courses taken by the student with ID 98765 4. Specify a SQL query to find names of all the courses taught by the computer science department in 2010 Spring
Expert Answer
SELECT name FROM INSTRUCTOR WHERE dept_name = "Biology"; SELECT query select name from database FROM command is used to specify the INSTRUCTOR table W