The stores table contains the following data:
store_id city state
----------- ------------------------- -----
1 Big Sur CA
2 Monterey CA
3 Napa CA
4 Oceanside CA
5 Rancho Bernardo CA
6 Sonoma CA
7 Algiers Point LA
8 New Orleans LA
9 Charlotte NC
10 North Wilkesboro NC
11 Midway UT
12 Moab UT
13 Park City UT
14 Springdale UT
15 Charleston WV
16 White Sulfur Springs WV
Given the following SQL statement:
SELECT city
, state
, SAMPLEID
FROM stores
SAMPLE WITH REPLACEMENT
WHEN state = 'LA' THEN 4, 1
WHEN state = 'CA' THEN 8, 4
WHEN state = 'CO' THEN 2, 2
END
ORDER BY 3;
How many rows are returned?
Reveal Solution
Next Question