FIT
100
More Complex Queries and SQL Functions
;
SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE
FROM PRODUCT
WHERE P_INDATE < 9/15/96
AND P_PRICE <= 50.00
ORDER BY V_CODE DESC, P_PRICE DESC;
A Query Based on Multiple Restriction