Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Having this information. Students Attribute Name Data Type StudentID char(11) FirstName varchar(20) LastName varchar(20) Gender char(1) DateofBirth date Courses Attribute Name Data Type CourseCode varchar(6) CourseName varchar(70) Level char(2) Credits int   Registration Attribute Name Data Type StudentID char(11) CourseCode varchar(6) Grade decimal(2, 1)   Write SQL code to:  1. How many courses are there on each level? 2. What is the average grade of courses that have been taken by the student with student ID 861103-2438?   3. Which students (studentID only) have the highest grade for the course ‘CS052’? 4.  Find the courses (course codes only) that have been taken by both the student 861103-2438 and the student 123456-0980.

Having this information. Students Attribute Name Data Type StudentID char(11) FirstName varchar(20) LastName varchar(20) Gender char(1) DateofBirth date Courses Attribute Name Data Type CourseCode varchar(6) CourseName varchar(70) Level char(2) Credits int   Registration Attribute Name Data Type StudentID char(11) CourseCode varchar(6) Grade decimal(2, 1)   Write SQL code to:  1. How many courses are there on each level? 2. What is the average grade of courses that have been taken by the student with student ID 861103-2438?   3. Which students (studentID only) have the highest grade for the course ‘CS052’? 4.  Find the courses (course codes only) that have been taken by both the student 861103-2438 and the student 123456-0980.

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter8: Advanced Sql
Section: Chapter Questions
Problem 40P
See similar textbooks
icon
Related questions
Question

Having this information.

Students
Attribute Name Data Type
StudentID char(11)
FirstName varchar(20)
LastName varchar(20)
Gender char(1)
DateofBirth date

Courses
Attribute Name Data Type
CourseCode varchar(6)
CourseName varchar(70)
Level char(2)
Credits int  

Registration
Attribute Name Data Type
StudentID char(11)
CourseCode varchar(6)
Grade decimal(2, 1)  

Write SQL code to: 

1. How many courses are there on each level?

2. What is the average grade of courses that have been taken by the student with
student ID 861103-2438?  

3. Which students (studentID only) have the highest grade for the course ‘CS052’?

4.  Find the courses (course codes only) that have been taken by both the student
861103-2438 and the student 123456-0980.  

Expert Solution
Step 1

The SQL queries are given below with demo data in the tables

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 8 steps with 7 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
SEE MORE TEXTBOOKS