Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Database Systems For Integration Of Media And User Environments 98

Authors: Yahiko Kambayashi, Akifumi Makinouchi, Shunsuke Uemura, Katsumi Tanaka, Yoshifumi Masunaga

1st Edition

9810234368, 978-9810234362

More Books

Students also viewed these Databases questions

Question

Describe the five elements of the listening process.

Answered: 1 week ago