Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQLList the student names of which are minoring in CINF or ITEC with classes ( classId ) , Course Title, and grade they received. Further,

SQLList the student names of which are minoring in CINF or ITEC with classes (classId), Course Title, and
grade they received. Further, if a grade is missing, show an empty string.
+---------+---------+---------+-------------------------------------+-------+
| fname | lname | classId | Course Title | grade |
+---------+---------+---------+-------------------------------------+-------+
| Tony | Hawk |10000| Data Structures | A |
| Tony | Hawk |10001| Design of Database Systems | A |
| Tony | Hawk |10002| DBMS | B+|
| Tony | Hawk |10003| Introduction to Information Systems | C |
| Tony | Hawk |10004| Web Application Development | A-|
| Tony | Hawk |11001| Design of Database Systems | D |
| Mary | Hawk |10000| Data Structures ||
| Mary | Hawk |10001| Design of Database Systems | A-|
| David | Hawk |10000| Data Structures | B-|
| David | Hawk |10002| DBMS | B+|
| David | Hawk |10003| Introduction to Information Systems | D |
| Lillian | Johnson |10004| Web Application Development | C+|
| Lillian | Johnson |10005| Database Development | A |
+---------+---------+---------+-------------------------------------+-------+
13 rows in set (0.001 sec)SQL
image text in transcribed

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

Essential SQLAlchemy Mapping Python To Databases

Authors: Myers, Jason Myers

2nd Edition

1491916567, 9781491916568

More Books

Students also viewed these Databases questions

Question

Is there anything out of bounds?

Answered: 1 week ago