Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4- Find the names of all students who have taken any Comp. Sci. course ever (there should be no duplicate names). (USE subquery) 5-
4- Find the names of all students who have taken any Comp. Sci. course ever (there should be no duplicate names). (USE subquery) 5- Find the number of instructors in each department who teach a course in the Spring 2018 semester. 6- Find the names of all instructors, along with their department names and department building name (USE JOIN) section Course id zec_id semester year building room_number time_slot jd classroom building room number capacity takes ID course id sec id semester year grade time_slot time_slot id day start time end time teaches ID course id rec_id semester year course course id title dept_name credits prereq course id prere id student ID name dept_name 101 cred department dept_name building budget instructor ID name dept_name salary advisor aid
Step by Step Solution
There are 3 Steps involved in it
Step: 1
SQL Queries with Subqueries and Joins 4 Students who took any Comp Sci course SQL SELECT DISTINCT na...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started