Question: (Hi, i need the SQL query code/syntax for the folowing questions. I have already created the database, i just dont know how to type the

(Hi, i need the SQL query code/syntax for the folowing questions. I have already created the database, i just dont know how to type the SQL queries) Thanks!

(P.S. I am using PostgreSQL if that makes a difference)

Consider the following database schema with the following relations:

Student (SID, Name, Address, Telephone, Age) Course (CourseNo, Title, Department, NumberOfCredits, CourseFees) Registration (SID, CourseNo, startDate, CompleteDate, Grade)

Consider the following queries:

  • List the student numbers and names of students who received a grade greater or equal to 70% in the course "COMP418," sorted by age ascending.
  • List the course numbers and titles of courses that have more than 10 students getting a grade lower than 50. [(Use group by courseNo and count(SID)].
  • List the course numbers and titles of courses whose course fees are between 400 and 600 dollars.
  • List all courses in the database.
  • Update all the course fees by adding 6 dollars to each course.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!