![subject](/tpl/images/cats/informatica.png)
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ā).
![ansver](/tpl/images/cats/User.png)
Answers: 3
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 01:30
What kind of motivation is katrina showing? use the drop-down menu to complete the statement. katrina is using motivation because she is personally interested in learning more.
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 03:00
Which action describes an aspect of technological design?
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 09:50
17. implement the jvm dload instruction for the mic-2. it has a 1-byte index and pushes the local variable at this position onto the stack. then it pushes the next higher word onto the stack as well
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 11:00
What are two of the most common reasons that peolpe who need mental health care do not access it?
Answers: 1
You know the right answer?
Consider the following relational schema, where the primary keys are Bold,
Students(sid, snam...
Students(sid, snam...
Questions
![question](/tpl/images/cats/fizika.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 14.12.2019 18:31
![question](/tpl/images/cats/mat.png)
Mathematics, 14.12.2019 18:31
![question](/tpl/images/cats/mat.png)
Mathematics, 14.12.2019 18:31
![question](/tpl/images/cats/health.png)
Health, 14.12.2019 18:31
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 14.12.2019 18:31
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/himiya.png)
Chemistry, 14.12.2019 18:31
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/biologiya.png)
Biology, 14.12.2019 18:31
![question](/tpl/images/cats/himiya.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/istoriya.png)
History, 14.12.2019 18:31
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/istoriya.png)