- You Have 30 Minutes 1 (66.71 KiB) Viewed 24 times
you have 30 minutes
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
you have 30 minutes
you have 30 minutes
20 Activity 6 Table name: Student2 Table name: Course2 STUDID STNAME LVL COURSEGPA CID CNAME TOTALNO DEPT 725123 Ali Diploma ITIS104 3.2 ITIS 104 Multimedia IT Adv 725124 Salim BS123 Diploma 2.45 BS123 Business Ethics15 Adv 728125 Maha EN1100 2.25 EN1100 Machines Diploma EN 725126 Ahmed Diploma EN2200 2.85 EN2200 Mechanics 28 EN 725127 Ali Diploma BS123 3.4 ITIS 108Database BS 16 35 IT Refer to the tables above and write SQL queries given below: 1. Find the names of the courses Ms. Maha is studying. 2. Find the courses in which some students are registered. 3. Find the student who is having the highest GPA. 4. How many rows are there in Student2 table? 5. Find the number of students registered in the course where student 725123 is registered. 6. What is the department student 725123 is studying in? 7. Find the students who are studying the course Mechanics. 8. Find the students with GPAs greater than the average GPA of all students.
20 Activity 6 Table name: Student2 Table name: Course2 STUDID STNAME LVL COURSEGPA CID CNAME TOTALNO DEPT 725123 Ali Diploma ITIS104 3.2 ITIS 104 Multimedia IT Adv 725124 Salim BS123 Diploma 2.45 BS123 Business Ethics15 Adv 728125 Maha EN1100 2.25 EN1100 Machines Diploma EN 725126 Ahmed Diploma EN2200 2.85 EN2200 Mechanics 28 EN 725127 Ali Diploma BS123 3.4 ITIS 108Database BS 16 35 IT Refer to the tables above and write SQL queries given below: 1. Find the names of the courses Ms. Maha is studying. 2. Find the courses in which some students are registered. 3. Find the student who is having the highest GPA. 4. How many rows are there in Student2 table? 5. Find the number of students registered in the course where student 725123 is registered. 6. What is the department student 725123 is studying in? 7. Find the students who are studying the course Mechanics. 8. Find the students with GPAs greater than the average GPA of all students.