SAP
C_TAW12_740 · Question #28
You count all customers within the same country and city. You want to display only the cities where three ar more customers exist. Which of the following SQL statements should you use?
The correct answer is A. SELECT country city COUNT(*) AS number FROM customers INTO TABEL it_customers B. SELECT country city FROM customers INTO TABEL it_customers GROUP BY country city. See the full explanation below for the reasoning.
Question
You count all customers within the same country and city. You want to display only the cities where three ar more customers exist. Which of the following SQL statements should you use?
Options
- ASELECT country city COUNT(*) AS number FROM customers INTO TABEL it_customers
- BSELECT country city FROM customers INTO TABEL it_customers GROUP BY country city
- CSELECT country city cust_name COUNT(*) AS number FROM customers INTO TABEL
- DSELECT country city cust_name FROM customers INTO TABEL it_customers GROUP BY
How the community answered
(33 responses)- A76% (25)
- C6% (2)
- D18% (6)
Community Discussion
No community discussion yet for this question.