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 of 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

Based on the Table Below, Which of the Following Statements