Assume a table SALES with sales of a product across all states in USA. Assume there is a column State in that table and that values are the USPS two character state abbreviation. Now select the statement that will give retrieve the sales from Connecticut (CT) and New York (NY).
SELECT *
FROM SALES
WHERE NOT STATE = 'CT'
OR STATE = 'NY'
SELECT *
FROM SALES
WHERE STATE = 'CT'
OR STATE = 'NY'
SELECT *
FROM SALES
WHERE STATE = 'CT'
AND STATE = 'NY'
SELECT *
FROM SALES
WHERE STATE = 'CT'
AND NOT STATE = 'NY'
1
Expert's answer
2018-04-25T08:57:16-0400
(b) SELECT * FROM SALES WHERE STATE = 'CT' OR STATE = 'NY'
Numbers and figures are an essential part of our world, necessary for almost everything we do every day. As important…
APPROVED BY CLIENTS
Finding a professional expert in "partial differential equations" in the advanced level is difficult.
You can find this expert in "Assignmentexpert.com" with confidence.
Exceptional experts! I appreciate your help. God bless you!
Comments
Leave a comment