Based on the SQL Shown, Which Query Finds How Many

question 25

Multiple Choice

Based on the SQL shown, which query finds how many items are in the TOY category? Items (ItemNum, Description, OnHand, Category, Storehouse, Price )

• A)SELECT SUM(*) FROM Items WHERE Category='TOY' ;
• B)SELECT COUNT(*) FROM Items WHERE Category='TOY' ;
• C)SELECT COUNT FROM Items WHERE Category='TOY' ;
• D)SELECT COUNT* FROM Items WHERE Category='TOY' ;

---

Definitions:

Non-normal Populations

Populations that do not follow a normal distribution, which affects the choice of statistical methods used.

Independently

Without being influenced by others or by external factors; in statistics, refers to events that have no effect on the likelihood of other events occurring.

Sampling Distribution

The calculated probability distribution relevant to a specific statistic, achieved by random sampling.

Sample Mean Difference

The difference between the average values of two samples drawn from a population.