Based on the code above,find how many parts are in item class HW.
A)SELECT SUM(*) FROM Part WHERE Class='HW' ;
B)SELECT COUNT(*) FROM Part WHERE Class='HW' ;
C)SELECT COUNT FROM Part WHERE Class='HW' ;
D)SELECT COUNT* FROM Part WHERE Class='HW' ;

Question

Quizplus · Accepted Answer

The correct SQL query to find the number of parts in item class HW is by using COUNT(*). Option B provides the correct syntax as it uses COUNT(*) with WHERE clause to filter the result. Option A is incorrect as SUM(*) is used to calculate the total value of a column. Option C is incorrect because COUNT should be followed by * or column name, otherwise it will show an error. Option D is incorrect because COUNT should be followed by * or column name, and without parentheses and it will show an error.

Based on the Code Above,find How Many Parts Are in Item