Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Refer to this table for the following questions. a) Using SQL, please indicate the correct way to retrieve a list of all the students names

Refer to this table for the following questions.

image text in transcribed

a) Using SQL, please indicate the correct way to retrieve a list of all the students names (Name) from the table Students

b) Provide the SQL statement that will retrieve a list of names for students who live in the US.

c) Provide the SQL statement that will return a list of student IDs and student names for all students in the MBA program.

\begin{tabular}{|c|l|l|l|l|l|} \hline ID & Name & Zipcode & Country & Degree & GPA \\ \hline 001 & Chris Martin & EX2 4NF & UK & BBA & 3.1 \\ \hline 002 & Ariana Grande & 33428 & USA & BBA & 3.5 \\ \hline 003 & BeyonceKnowles & 90077 & USA & MBA & 4.0 \\ \hline 004 & Bruno Mars & 91604 & USA & MBA & 3.0 \\ \hline 005 & Taylor Swift & 37212 & USA & BBA & 3.9 \\ \hline 006 & ShawnMendes & L1X 1H4 & CA & MBA & 4.0 \\ \hline \end{tabular}

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

PostgreSQL Up And Running A Practical Guide To The Advanced Open Source Database

Authors: Regina Obe, Leo Hsu

3rd Edition

1491963417, 978-1491963418

More Books

Students also viewed these Databases questions