Question: Course Table SID FIRST LAST S103 John Smith S104 CODE Mary TITLE Jones BOS Database Systems S105 Jane PRI Brown PR2 S106 Programing Programing 2




Course Table SID FIRST LAST S103 John Smith S104 CODE Mary TITLE Jones BOS Database Systems S105 Jane PRI Brown PR2 S106 Programing Programing 2 Mathematics Mark Jones MA S107 John Brown rades Table SID CODE MARK S103 DES 5103 30 5104 DR1 06 5104 MA 35 $106 PR 5102 MA 35 5107 PR2 Activate Windows Go to Settings 10 actriate Wings Use subquery to find the students IDs who scored more than the average mark. [use Grades Table] Write the SQL statements to get the student first name and marks for all students whose name starts with the letter 'M'. [use Students and Grades Tables] Write a SQL query to find a list of the student ID and who have passed the course (scores 40 or more). [use Grades Table] Vrite SQL statements to display the student ID, marks and new column called Point, evaluate the data in the new column as follows: -If the student mark is more than 80 then the grade is 4 -If the student mark is more than 70 then the grade is 3 -Otherwise, the grade is 2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
