Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database management systems

Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff

3rd edition

72465638, 978-0072465631

More Books

Students also viewed these Programming questions