Answer to Question #76380 in Databases | SQL | Oracle | MS Access for J

Question

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'

Answer 1

(b) SELECT *
FROM SALES 
WHERE STATE = 'CT'
OR STATE = 'NY'