Chapter 11, Problem 24P

Problems 22–24 are based on the following query:

SELECT	P_CODE, P_DESCRIPT, P_PRICE, P.V_CODE, V_STATE
FROM	PRODUCT P, VENDOR V
WHERE	P.V_CODE = V.V_CODE
	AND V_STATE = 'NY'
	AND V_AREACODE = '212'
ORDER BY	P_PRICE;

Write the command(s) used to generate the statistics for the PRODUCT and VENDOR tables.