Write queries in SQL to answer each of the following questions: ************************************************************************************************ (Table: instructor (ID, name, dept_name, salary) student (ID, name, dept_name, tot_cred) teaches (ID, course_id, sec_id, semester, year) takes (ID, course_id, sec_id, semester, year, grade) ) Find the names of all instructors from Music department whose name includes the substring 'ric'. Find the names of all students from Physics department and convert the names to lowercase. Find the names of all instructors and order the names in descending. Find all instructors in Finance department who have taught some course in 2008. Find all students from Physics department who took course 'CS-319'.
Write queries in SQL to answer each of the following questions: ************************************************************************************************
(Table: instructor (ID, name, dept_name, salary)
student (ID, name, dept_name, tot_cred)
teaches (ID, course_id, sec_id, semester, year)
takes (ID, course_id, sec_id, semester, year, grade) )
Find the names of all instructors from Music department whose name includes the substring 'ric'.
Find the names of all students from Physics department and convert the names to lowercase.
Find the names of all instructors and order the names in descending.
Find all instructors in Finance department who have taught some course in 2008.
Find all students from Physics department who took course 'CS-319'.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
4. Find all instructors in Finance department who have taught some course in 2008.
5. Find all students from Physics department who took course 'CS-319'.
by Bartleby Expert
