SQL Quick Reference Guide
Statements 

SELECT [ DISTINCT ] * | LIST OF COLUMNS, FUNCTIONS, CONSTANTS
   FROM LIST OF TABLES OR VIEWS
   [ WHERE CONDITION(S) ]
   [ ORDER BY ORDERING COLUMN(S) [ ASC | DESC ] ]
   [ GROUP BY GROUPING COLUMN(S) ]
   [ HAVING CONDITION(S) ]

DELETE FROM TABLE NAME
    [ WHERE CONDITION(S) ] 

 INSERT INTO TABLE NAME
    [ (COLUMN LIST) ]
    VALUES (VALUE LIST) 

UPDATE TABLE NAME
    SET COLUMN NAME = VALUE
    [ WHERE CONDITION ]

Functions 

Function
Purpose

SUM
Total of the values in a field.

AVG
Average of the values in a field.

MIN
Lowest value in a field.

MAX
Highest value in a field.

COUNT
Number of values in a field, not counting Null (blank) values.

Predicates 

Predicate
Description

BETWEEN ... AND
Compares a value to a range formed by two values.

IN
Determines whether a value exists in a list of values or a table.

LIKE
Compares, in part or in whole, one value with another.

JOIN
Joins two tables.

Data Definition 

CREATE TABLE TABLE_NAME
    ( COLUMN_NAME DATA_TYPE [(SIZE)] COLUMN_CONSTRAINT,
    [, other column definitions,...]
    [, primary key constraint]
    )

ALTER TABLE TABLE_NAME ADD | DROP | MODIFY
    ( COLUMN_NAME DATA_TYPE [(SIZE)] COLUMN_CONSTRAINT,
    [, other column definitions,...]
    )

DROP TABLE TABLE_NAME

CREATE [UNIQUE] [ASC | DESC] INDEX INDEX_NAME
    ON TABLE_NAME ( COLUMN_LIST ) 

DROP INDEX INDEX_NAME ON TABLE_NAME 

 CREATE VIEW VIEW_NAME AS QUERY_NAME 

 CONSTRAINT CONSTRAINT_NAME
     {PRIMARY KEY | UNIQUE | NOT NULL | 
     REFERENCES FOREIGN_TABLE [(FIELD_LIST)]}