Based on the code shown, which query finds how many items are in category TOY???Item (ItemNum, Description, OnHand, Category, Storehouse, Price )
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

Quizplus · Accepted Answer

The correct query is "SELECT COUNT(*) FROM Item WHERE Category='TOY' ;". The COUNT function is used to return the number of rows that match the given condition in the WHERE clause. In this case, we want to count the number of items that belong to the category "TOY". Therefore, the correct answer is option B.

Based on the Code Shown, Which Query Finds How Many