Question: Q3: (20 Points): Write the SQL commands for the following queries (use Figure2): Q3.A) Count the number of the registered students in the Advanced Database

Q3: (20 Points): Write the SQL commands for the following queries (use Figure2): Q3.A) Count the number of the registered students in the "Advanced Database Systems" course during the year 2021. Q3.B) Find the names of all the students and the average grade for each of them during the year 2019(for all the registered courses during that year). Q3.C) List the names of all students who registered in courses offered by "Computer Engineering" department during the year 2021. Q3.D) For each Course on which more than 10 students registered, retrieve the Course_ID, the Course title, and the number of students who registered in the course. Given the following Sample Database answer the next 3 questions (Q2.03&04): Student Student_ID 100 200 Course Course ID E001 Num_Credits 4 E002 4 Sname Start_year Ali 2018 Omer 2018 Same 2019 Lana 2019 Title Dep_ID Database 1000 Programming! 1000 Chemistry A 2000 Chemistry B 2000 Math1 3000 CH001 3 300 CH002 3 400 MA001 3 3 Register Student_ID 100 Year Grade Course_ID E001 78 2018 2019 100 E002 80 Department Dep ID Dname 1000 Computer Engineering 2000 Chemistry 3000 Mathematics 100 2020 85 MA001 E001 200 2018 90 200 E002 2019 90 300 CH001 2019 65 300 CHOO2 2020 70 E001 2019 88 400 400 E002 2020 87
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
