Specifies the Columns or Fields that you wish to have shown in the results of the Query.
What is "SELECT"
100
The ____ clause specifies the source Table(s) for the data selected by the Query.
What is "FROM"
100
The GROUP BY clause, if present, groups the ______ returned by the Query, allowing us to apply an Aggregate Function to a value field.
What is "Rows (Records)"
100
____ is the SQL key word which refers to the Relationship between the data in multiple tables.
What is "JOIN"
100
A ____ gives us the ability to SELECT certain data from a data source (it's the generic term for a basic SELECT statement)
What is a "Query"
200
The _____ clause, if present, limits the Rows (Records) returned by the query, by applying certain conditions that must be met in the values of one or more Columns (Fields) referenced by the Query.
What is "WHERE"
200
This key word was added to SQL because the WHERE key word could not be applied against Aggregate Functions (like SUM).
What is "HAVING"
200
In a typical Group and Total type Query, we will group by one or two ______ fields (an _____ is a Person, Place, or Thing, like Customer or Product), and then apply an aggregate function to a value field.
What is "Entity"
200
In a relational database, a JOIN should always be stated using the ________ Key from the ONE-side table to the ________ Key from the MANY-side table.
What is "Primary .... Foreign"
200
SQL stands for ______ ______ ______
What is "Structured Query Language"
300
The HAVING clause, if used, must appear after the __________ clause in a SQL statement
What is "GROUP BY"
300
This clause, if present, will always be the last line in an SQL statement.
What is "ORDER BY"
300
SUM, AVERAGE, MIN, MAX, FIRST, LAST, and COUNT are also known as _________ Functions.
What is "Aggregate"
300
The _____ JOIN is used to retrieve all rows from the MANY-side table, whether or noth there are matching values on the ONE-side table.
What is "RIGHT"
300
CREATE, ALTER, or DROP are all examples of _ _ _
What is "DDL"
400
The ________ key word, if present, eliminates duplicate rows in the query results. It is used immediately after the SELECT key word, as in SELECT ________.
What is "DISTINCT"
400
The ______ clause is used where selectivity criteria needs to be supplied on a Column (Field) in a Group and Total type Query.
What is "Having"
400
If you use a GROUP BY clause, it must come after the ______ clause.
What is "Where"
400
The _____ JOIN is the default join used in MS Access. It retrieves all rows where there is a value on BOTH sides of the join.
What is "INNER"
400
DML stands for
What is "Data Manipulation Language"
500
Select statements can include Calculated Fields that do not exist in the Tables. A Calculated Field must be given a ____, using the __ keyword. Answer one or the other for credit.
What is an "Alias" using the "AS" keyword.
500
This operator is used to join the result sets from two queries having like Columns (Fields). When used, you will see two complete SQL statements, and the ______ key word between them.
What is "UNION".
500
DAILY DOUBLE! (1,000). Of the aggregate functions, which would you use in combination with a GROUP BY clause to give you the "Latest Order Date for each Product"?
What is "MAX"
500
The _____ JOIN is used to retrieve all rows from the ONE-side table, whether or not there are matching values on the MANY-side table.