Based on the table below, which of the following statements will return the number of customers in Michigan (MI)?
Customer table

A) SELECT COUNT(*) FROM Customer WHERE State = 'MI'
B) SELECT AVG(*) FROM Customer WHERE State = 'MI'
C) SELECT MAX(*) FROM Customer WHERE State = 'MI'
D) SELECT SUM(*) FROM Customer WHERE State = 'MI'

Question

Based on the table below, which of the following statements will return the number of customers in Michigan (MI)?
Customer table

A) SELECT COUNT(*) FROM Customer WHERE State = 'MI' 
B) SELECT AVG(*) FROM Customer WHERE State = 'MI' 
C) SELECT MAX(*) FROM Customer WHERE State = 'MI' 
D) SELECT SUM(*) FROM Customer WHERE State = 'MI'

Quizplus · Accepted Answer

The Answer is A

Based on the Table Below, Which of the Following Statements