Specifies the Columns or Fields that you wish to have shown in the results of the Query.
What is "SELECT"
100
This clause bins results by a given field or fields
What is GROUP BY
100
This function is used to find the combined values of a numeric field
What is sum()
100
The ___ JOIN will return items that are common in TableA and TableB
SELECT * FROM TableA
____ JOIN TableB
ON TableA.name = TableB.name
What is "INNER 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 clause is used as a conditional evaluation (ie assign age to an age bracket)
What is CASE
200
This function returns the number of rows of a field or table
What is count()
200
This is the term to refer to two fields that link two tables together
What is FOREIGN KEY
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 is used to create a temporary table from which you can query
What is WITH
300
These two functions return the largest and smallest numeric values of a given field
What are min() and max()
300
This JOIN will return all values in TableA:
SELECT * FROM TableA
____ JOIN TableB
ON TableA.name = TableB.name
What is "LEFT JOIN"
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
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.