In a SELFCT query, what is the difference between a WHERE clause and a HAVING claus

Explain why the following command would create an trror and what changes could be to fix the error SELECI V CODE, SUM$($P$\_$ QOH$)$ FROM PRODUCT;

What type of integrity is enforced when a primary key is declared?

Explain why it might be more appropriate to declare an attribute that contains only die character data type instead of a numeric data type.

What is the difference between a column constraint and a table constraint?

What are "referential constraint actions"?

Hewrite the following WHERE clause without the use of the IN special operator: WHERE

$V$ STATE IN $[\text{'}$TN$\text{'},\text{'}$FL$\text{'},\text{'}$GA$\text{'}]$

Explain the difference between an ORDFR AY clause and a GROUP EY clause.

Explain why the following two cammands produce different resalts: SELECI DISTINCTC $($V$\_$CODE$)$ FROM PRODUCE; SELECT COUNT $($DISTINCTV CODE$)$ FROM PRODUCT; $10.$ What is the difference between the COUNI aggregate function and the SUM abgregate function?