Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

write a sql statement to retrieve the ID and full name of all students who got a grade of B in the class cs101 PK

write a sql statement to retrieve the ID and full name of all students who got a grade of "B" in the class "cs101"
image text in transcribed
PK STUDENT_ID FIRST_NAME LAST_NAME MIDDLE_INITIAL STREET_1 STREET_2 CITY POSTAL_CODE STUDENTS BIGINT VARCHAR(50) VARCHAR(50) CHAR(1) VARCHAR(50) VARCHAR(50) VARCHAR(30) VARCHAR(10) NOT NULL NOT NULL NOT NULL NULL NOT NULL NULL NOT NULL NOT NULL PK CLASS_ID CLASS_CODE CLASS_NAME CLASSES BIGINT VARCHAR(5) VARCHAR(50) NOT NULL NOT NULL NOT NULL FK CLASS_GRADES PK CLASS_GRADES_ID BIGINT CLASSID BIGINT FK STUDENT ID BIGINT FK INSTRUCTOR_ID BIGINT GRADE VARCHAR(50) NOT NULL NOT NULL NOT NULL NOT NULL NULL INSTRUCTORS INSTRUCTOR ID BIGINT FIRST_NAME VARCHAR(50) MIDDLE INITIAL CHAR(1) LAST_NAME VARCHAR(50) NOT NULL NOT NULL NOT NULL NOT NULL to the date

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_2

Step: 3

blur-text-image_3

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

Temporal Databases Research And Practice Lncs 1399

Authors: Opher Etzion ,Sushil Jajodia ,Suryanarayana Sripada

1st Edition

3540645195, 978-3540645191

More Books

Students also viewed these Databases questions

Question

Chapter Eleven Real-world Case #1

Answered: 1 week ago

Question

d. Who are important leaders and heroes of the group?

Answered: 1 week ago