Question

Subject : computer science -web development

Qus: using the database tables below write the SQL queries:

( SELECT; FORM; WHERE; ORDER BY; DISTINCT; GROUP BY; COUNT(); SUM(); AVG(); MAX(); MIN(); JOIN; ON)

Student (StudentId, Major, GPA)

Transcript( Studentid, CourseNo, Gread);

Course( CourseNo, Title, Credits)

1. Display the title of the course(s) that are 3 credits?

2. Display the average GPA of the students Majoring in ‘CSC’

3. List non duplicated major(s) of students who have received a grades of ‘A’ in CSC350

4. List the course title  (in ascending alphabetical order0 and count of ‘F’ grades for each course

5. List the Studentid, Course title and grade of all students who are ‘CSC’ majors and have a GPA of 3.0 or above

Answer 1

If you have any doubts comment below

A)

select title from course where credits=3

B)

select AVG(GPA) from Student where Major="CSC"

C)

select distinct Student.major from Student join Transcript on Student.StudentId = Transcript.StudentId where Transcript.Grade="A" and CourseNo="CSC350"

D) select Course.title, count(Transcript.Grade) from Course,Transcript where Transcript.Grade = "F" orderby Course.title

E)

select Student.Studentid, Course.title, Transcript.Grade from Student,Course,Transcript where Student.Major="CSC" and Student.GPA>=3