Computers and Technology, 02.06.2020 21:57, SiegeHatake4534
Consider the following relational schema, where the primary keys are Bold,
Students(sid, sname, address, dept_id)
Courses(cid, cname, dept_id)
Departments(dept_id, dname, college)
Grades(sid, cid, year, semester, grade)
Write the following queries in SQL. Only use the tables that are absolutely needed for the corresponding query.
1. Find the sids and snames of students who took "Database" course (i. e., cname = ‘Database’) in Fall 2019.
2. Find the average grade of all the students who took "CS327" (i. e., cid=‘CS327’) in Fall 2019. You can assume grade is a numerical attribute.
3. Find the number of distinct courses offered by each department in Fall 2019.
4. Find the sids of students who have taken at least 10 different courses offered by "Computer Science" department (i. e., dname = ‘Computer Science’).
Answers: 3
Computers and Technology, 23.06.2019 20:30, summerhumphries3
What are some settings you can control when formatting columns?
Answers: 1
Computers and Technology, 23.06.2019 22:20, andrew412603
Learning sign language is an example of a(n) learning sign language is an example of a(n)
Answers: 2
Computers and Technology, 24.06.2019 15:50, GreatBaconGamer
Subscribe to j p g a m e t u b e on you tube ?
Answers: 2
Consider the following relational schema, where the primary keys are Bold,
Students(sid, snam...
Students(sid, snam...
English, 19.07.2020 01:01
Mathematics, 19.07.2020 01:01
Physics, 19.07.2020 01:01
Mathematics, 19.07.2020 01:01
Physics, 19.07.2020 01:01