Consider the following class database schema: Students (stuNo, fName, IName, add

Question

Consider the following class database schema:
Students (stuNo, fName, IName, address, DOB, sex, depNo)
Department (depNo, depName)
Instructor (instructorNo, depNo, fName, IName)
Class (classNo, className, instructorNo, depNo)
Registration (StuNo, classNo, semester)
StudyOn (stuNo, classNo, dateStudied, hoursStudied)

W E Bonus Questions (10.points): Continue to answer the following questions using the question Adatabase schema: 5.3 43 Find out how many students are taking all Dr. Lei Huang's dlasses in Fall 2017 54 44: Produce a report of the total hours studied by each students

Explanation / Answer

1. select count(s.stuNo) from Students s join Instructor  i on s.depNo=i.depNo join Class c on s.depNo=c.depNo where i.fname='Dr.Lei' and i.lname='Huang' and c.className='Fall 2017' ;

2. Select sum(hourStudied) from StudyOn group by stuNo;

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---