Instructor Fun Facts
Grab Bag
Functions
Joins
100
He is older of the two instructors
Who is Alan
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
Q1
What is "INNER JOIN"
200
He is taller of the two instructors
Who is Ewan
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
300
This is the name of Alan's dog
What is Taz
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
Q3
What is "LEFT JOIN"
M
e
n
u