SELECT COUNT(*) FROM TEAMSTATS WHERE HITS/AB < .35;
SELECT COUNT(*) NUM_BELOW_350 FROM TEAMSTATS WHERE HITS/AB < .35;
SELECT COUNT(*) FROM TEAMSTATS;
SELECT SUM(SINGLES) TOTAL_SINGLES FROM TEAMSTATS;
SELECT SUM(SINGLES) TOTAL_SINGLES, SUM(DOUBLES) TOTAL_DOUBLES, SUM(TRIPLES) TOTAL_TRIPLES, SUM(HR) TOTAL_HR FROM TEAMSTATS;
SELECT SUM(SINGLES) TOTAL_SINGLES, SUM(DOUBLES) TOTAL_DOUBLES, SUM(TRIPLES) TOTAL_TRIPLES, SUM(HR) TOTAL_HR FROM TEAMSTATS WHERE HITS/AB >= .300;
SELECT SUM(HITS)/SUM(AB) TEAM_AVERAGE FROM TEAMSTATS;
SELECT AVG(SO) AVE_STRIKE_OUTS FROM TEAMSTATS;
SELECT AVG(SO) AVE_STRIKE_OUTS FROM TEAMSTATS WHERE HR >= 5;
SELECT AVG(HITS/AB) TEAM_AVERAGE FROM TEAMSTATS;
SELECT AVG(HITS)/AVG(AB) TEAM_AVERAGE FROM TEAMSTATS;
SELECT MAX(HITS) FROM TEAMSTATS;
SELECT NAME FROM TEAMSTATS WHERE HITS = MAX(HITS);
SELECT MAX(NAME) FROM TEAMSTATS;
SELECT MIN(AB) FROM TEAMSTATS;
SELECT MIN(NAME) FROM TEAMSTATS;
SELECT MIN(AB), MAX(AB) FROM TEAMSTATS;
SELECT LASTNAME, UPPER(LASTNAME), FIRSTNAME, LOWER(FIRSTNAME) FROM CHARACTERS1;
SELECT LASTNAME, LTRIM(LASTNAME), FIRSTNAME, LTRIM(FIRSTNAME) FROM CHARACTERS2;
SELECT FIRSTNAME, SUBSTR(FIRSTNAME,2,3) FROM CHARACTERS3;
SELECT FIRSTNAME, SUBSTR(FIRSTNAME,3) FROM CHARACTERS3;
SELECT SUBSTR(PHONE,1,3)||'-'||SUBSTR(PHONE,4,2)||'-'||SUBSTR(PHONE,6,4) PHONE FROM PHONE_TABLE;
SELECT NAME, JOB, DEPARTMENT FROM JOB_TABLE;
SELECT SUBSTR(NAME, 1, 15) NAME, SUBSTR(JOB,1,10) JOB, SUBSTR(DEPARTMENT, 1, 10) DEPT FROM JOB_TBL;
SELECT ABS(A) ABSOLUTE_VALUE FROM NUMBERS;
SELECT B, CEIL(B) CEILING FROM NUMBERS;
SELECT A, FLOOR(A) FLOOR FROM NUMBERS;
SELECT A, SIGN(A) FROM NUMBERS;
SELECT A FROM NUMBERS WHERE SIGN(A) = 1;
SELECT ABS(A), SQRT(ABS(A)) FROM NUMBERS;
