Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
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