Question: Refer to the Customer table. Which query returns the result table below? The Customer table has columns CustomerId, Name, StreetAddress, and State. Customer has 1

Refer to the Customer table. Which query returns the result table below?
The Customer table has columns CustomerId, Name, StreetAddress, and State. Customer has 12 rows: 1, Klara Lane, 7096 Overlook Street, AZ 2, Deja Roderick, 857 North Bayberry Ave., IL 3, Janine Harstad, 321 Honey Creek St., NC 4, Alonso Zastrow, 8914 Magnolia St., NJ 5, Karisa Guidroz, 994 Bedford Street, TN 6, Marcos Larimer, 30 Sutor St., NY 7, Danyell Cartagena, 861 Fairview St., NY 8, Celine Song, 47 Hall Ave., NY 9, Grover Steiger, 9400 S Normandie Ave #14, CA 10, Al Burrell, 8424 Bowman St., NY 11, Latasha McNutt, 5723 Morgan Ave., CA 12, Lauri Hanes, 2045 W Jackson Blvd, IL The Result table has columns State and Count(*). Result has 3 rows: CA,2 IL,2 NY,4
Group of answer choices
SELECT State, COUNT(*)
FROM Customer
GROUP BY State
HAVING COUNT(*)>1;
SELECT State, COUNT(*)
FROM Customer
GROUP BY State
HAVING MAX(CustomerId)>1;
SELECT State, COUNT(*)
FROM Customer
GROUP BY State
WHERE SUM(CustomerId)>1;
SELECT State, COUNT(*)
FROM Customer
GROUP BY State
WHERE COUNT(*)>1;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!