SELECT ITEM, WHOLESALE, WHOLESALE + 15 FROM PRICE;
SELECT * FROM PRICE;
SELECT ITEM, WHOLESALE, (WHOLESALE + 15) RETAIL FROM PRICE;
SELECT ITEM PRODUCE, WHOLESALE, WHOLESALE + 25 RETAIL FROM PRICE;
SELECT STATE, -HIGHTEMP LOWS, -LOWTEMP HIGHS FROM HILOW;
SELECT STATE, HIGHTEMP LOWS, LOWTEMP HIGHS, (LOWTEMP - HIGHTEMP) DIFFERENCE FROM HILOW;
SELECT ITEM, WHOLESALE, (WHOLESALE/2) SALEPRICE FROM PRICE;
SELECT ITEM, WHOLESALE, WHOLESALE * 0.9 NEWPRICE FROM PRICE;
SELECT NUMERATOR, DENOMINATOR, NUMERATOR % DENOMINATOR REMAINDER FROM REMAINS;
SELECT N1+N2*N3/N4, (N1+N2)*N3/N4, N1+(N2*N3)/N4 FROM PRECEDENCE;
SELECT * FROM FRIENDS WHERE FIRSTNAME = 'JD';
SELECT * FROM FRIENDS WHERE FIRSTNAME = 'AL';
SELECT FIRSTNAME FROM FRIENDS WHERE FIRSTNAME = 'BUD';
select * from friends where firstname = 'Bud';
SELECT * FROM FRIENDS WHERE AREACODE > 300;
SELECT * FROM FRIENDS WHERE AREACODE >= 300;
SELECT * FROM FRIENDS WHERE ST < 'LA';
SELECT * FROM FRIENDS WHERE ST < 'la';
SELECT * FROM FRIENDS WHERE ST <= 'LA';
SELECT * FROM FRIENDS WHERE ST <> 'IL';
SELECT * FROM FRIENDS;
SELECT * FROM FRIENDS WHERE ZIP IS NULL;
SELECT * FROM FRIENDS WHERE ZIP = NULL;
SELECT * FROM PARTS WHERE LOCATION LIKE '%BACK%';
SELECT * FROM PARTS WHERE LOCATION LIKE 'BACK%';
SELECT * FROM PARTS WHERE NAME LIKE 'A%';
SELECT * FROM PARTS WHERE NAME LIKE 'a%';
SELECT * FROM FRIENDS2 WHERE ST LIKE 'C_';
SELECT * FROM FRIENDS2 WHERE PHONE LIKE '555-6_6_';
SELECT * FROM FRIENDS2 WHERE PHONE LIKE '555-6%';
SELECT * FROM FRIENDS2  WHERE FIRSTNAME LIKE '_L%';
SELECT FIRSTNAME || LASTNAME ENTIRENAME FROM FRIENDS2;
SELECT LASTNAME || ',' || FIRSTNAME NAME FROM FRIENDS2;
SELECT LASTNAME, YEARS * 12 - LEAVETAKEN REMAINING FROM VACATION WHERE LASTNAME LIKE 'B%' AND YEARS * 12 - LEAVETAKEN > 50;
SELECT LASTNAME FROM VACATION WHERE YEARS <= 5 AND LEAVETAKEN > 50;
SELECT LASTNAME WORKAHOLICS FROM VACATION WHERE YEARS >= 5 AND ((YEARS *12)-LEAVETAKEN)/(YEARS * 12) < 0.50;
SELECT LASTNAME WORKAHOLICS FROM VACATION WHERE YEARS >= 5 OR ((YEARS *12)-LEAVETAKEN)/(YEARS * 12) >= 0.50;
SELECT * FROM VACATION WHERE LASTNAME NOT LIKE 'B%';
SELECT * FROM FRIENDS WHERE ZIP IS NULL;
SELECT * FROM FRIENDS WHERE ZIP IS NOT NULL;
SELECT NAME FROM SOFTBALL UNION SELECT NAME FROM FOOTBALL;
SELECT NAME FROM SOFTBALL UNION ALL SELECT NAME FROM FOOTBALL;
SELECT * FROM FOOTBALL INTERSECT SELECT * FROM SOFTBALL;
SELECT * FROM FOOTBALL MINUS SELECT * FROM SOFTBALL;
SELECT * FROM SOFTBALL MINUS SELECT * FROM FOOTBALL;
SELECT * FROM FRIENDS2 WHERE ST = 'CA' OR ST ='CO' OR ST = 'LA';
SELECT * FROM FRIENDS2 WHERE ST IN('CA','CO','LA');
SELECT * FROM FRIENDS2 WHERE AREACODE IN(100,381,204);
SELECT * FROM PRICE WHERE WHOLESALE > 25 AND WHOLESALE < 75;
SELECT * FROM PRICE WHERE WHOLESALE BETWEEN 25 AND 75;
