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
Get step-by-step solutions from verified subject matter experts
