Based on the code above,find how many items are in category TOY.
A) SELECT SUM(*) FROM Item WHERE Category='TOY' ;
B) SELECT COUNT(*) FROM Item WHERE Category='TOY' ;
C) SELECT COUNT FROM Item WHERE Category='TOY' ;
D) SELECT COUNT* FROM Item WHERE Category='TOY' ;

Question

Based on the code above,find how many items are in category TOY.​
A) ​SELECT SUM(*) FROM Item WHERE Category='TOY' ;
B) ​SELECT COUNT(*) FROM Item WHERE Category='TOY' ;
C) ​SELECT COUNT FROM Item WHERE Category='TOY' ;
D) ​SELECT COUNT* FROM Item WHERE Category='TOY' ;

Quizplus · Accepted Answer

The correct syntax to count the number of items in a particular category is by using the COUNT(*) function in combination with the WHERE clause. Therefore, option B is the correct choice, as it uses the COUNT(*) function and filters results based on the Category 'TOY'. Options A, C, and D are incorrect because they use incorrect syntax or functions.

Based on the Code Above,find How Many Items Are in Category