SQL Syntax/Semantics Rules and Guidelines:

1.	Clause
a.	__________ limits which ___________/attributes are used.
b.	__________ identifies which ________ to use.
c.	__________ limits which ___________/tuples are used.
d.	________ ____ organizes __________ into groups based on attributes.
e.	A ________ clause MUST ALWAYS have a _________ clause.
2.	Conditions when deciding on rows
a.	____ NULL is not the same as _____ NULL
b.	NULL is not the same as _______
c.	When using wildcards (____ or ____) do not use ____ but use ______.
d.	If there is more than one table in the FROM clause (n tables), there is almost always at least ______ conditions in the WHERE clause.
3.	Nested queries
a.	If using a nested query and an _____ (or something similar), the subquery must return _____________ row(s).
b.	If using a nested subquery and IN, ___, ___, etc., the subquery can return multiple rows, but only ____ ________.
c.	If using exists/not exists, the queries must be ________.

4.	
Other
a.	Order of rows is only guaranteed when there is a ____________ clause.
b.	The only attributes allowed in the ______ clause when there is a GROUP BY clause are __________________ or ___________________ on those attributes.
c.	You can’t have an attribute in the WHERE or SELECT clauses without the corresponding _______ in the FROM clause.
d.	If you are using the UNION, _____________ or _________ operators, the tables must be ____________ __________________.
e.	If you want to have an “all of an all” (example: all students that have taken all courses taught by a professor), you must use a ______________________.
5.	Layout Guidelines
a.	Where there are ________ components to the ______ clause, use _________ to add clarity.
b.	Be consistent with _______/______ case with reserved words.
c.	Use __________ to make it very readable (and be consistent).
d.	Limit the _______ of the line to ________________!
6.	Overall concepts
a.	If the output is correct then the statement is _______________________.
b.	KISS _____________________________________________________.
c.	________ are simpler than nested queries.
d.	A ________ can always be written as a ____________ but the opposite is not always true.