TDS-C01 practice question 33 of 35

Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)? Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?

Full set: 316 questions
Answer options
A: 592,593
B: 293,202
C: 416,702 Correct answer
D: 336,908
Correct Answer:
C. 416,702
Explanation

Since you need BOTH State and the YEAR, we need to use an Inner Join. Follow the steps below:

Scroll to Top