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 SELECT COUNT(*) function will return the number of customers in Michigan (MI) by counting the rows where the State column equals 'MI'. The other functions (AVG, MAX, SUM) are used for calculating average, maximum, and sum of numerical values, and are not applicable to a non-numerical column like State.

Based on the Table Below, Which of the Following Statements