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

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

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 Databases Questions!