Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Retrieve the ID and name of the students who enrolled in CST 235 in Spring 2021. Note that 'Spring 2021' is a valid

 

1. Retrieve the ID and name of the students who enrolled in CST 235 in Spring 2021. Note that 'Spring 2021' is a valid value of the column semester. Using ANSI JOIN when pulling data from several tables. *********** Output **** Student ID Last Name | Last Name 950222114 950222832 950344597 Leon 950569260 | James 950689252 Gary 950784368 | Sarrayyah John Jasmine 6 rows in set (0.002 sec) ***** Martin Barnes | Franklin Noel Jennings Kenndy ****

Step by Step Solution

There are 3 Steps involved in it

Step: 1

It appears that you want to retrieve the ID and name of st... 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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions