56. A: SELECT CUSTNAMEFROM CUSTOMERWHERE HQCITY IN (‘Atlanta’, ‘Chicago’, ‘Washington’);B: SELECT* FROM CUSTOMERWHERE HQCITY = ‘Atlanta’ OR HQCITY=‘Chicago’ AND HQCITY=‘Washington’;C: SELECT*FROM CUSTOMERWHERE HQCITY IN (‘Atlanta; ‘Chicago’, ‘Washington’;D: SELECT CUSTNAMEFROM CUSTOMERWHERE HQCITY =‘Atlanta’ AND HQCITY = ‘Chicago’ AND HQCITY=‘Washington’; 56.Customer tableCUSTNUMCUSTNAMESPNUMHQCITY0121Company A137New York0630Company B196Chicago0033Company C137Los Angeles1047Company D137Los Angeles1525Company E361Atlanta1700Company F361Washington1826Company G137New York2196Company H204New York2267Company I196New YorkWhich SELECT statement retrieves the customer recordsfor those customers headquartered in Atlanta, Chicago, orWashington?

Consider the given Options : A: SELECT CUSTNAME FROM CUSTOMER WHERE HQCITY IN (‘Atlanta’, ‘Chicago’,…

Answered: CUSTNAME FROM CUSTOMER WHERE HQCITY IN…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

100%

56. A: SELECT CUSTNAME FROM CUSTOMER WHERE HQCITY IN (‘Atlanta’, ‘Chicago’, ‘Washington’); B: SELECT* FROM CUSTOMER WHERE HQCITY = ‘Atlanta’ OR HQCITY=‘Chicago’ AND HQCITY=‘Washington’; C: SELECT* FROM CUSTOMER WHERE HQCITY IN (‘Atlanta; ‘Chicago’, ‘Washington’; D: SELECT CUSTNAME FROM CUSTOMER WHERE HQCITY =‘Atlanta’ AND HQCITY = ‘Chicago’ AND HQCITY=‘Washington’;

56.
Customer table
CUSTNUM
CUSTNAME
SPNUM
HQCITY
0121
Company A
137
New York
0630
Company B
196
Chicago
0033
Company C
137
Los Angeles
1047
Company D
137
Los Angeles
1525
Company E
361
Atlanta
1700
Company F
361
Washington
1826
Company G
137
New York
2196
Company H
204
New York
2267
Company I
196
New York
Which SELECT statement retrieves the customer records
for those customers headquartered in Atlanta, Chicago, or
Washington?

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions