sql-join/aggregates

Question 1

What is a foreign key?

Answer 1

links related tables together

Question 2

How do you join two SQL tables?

Answer 2

join clause

Question 3

How do you temporarily rename columns or tables in a SQL statement?

Answer 3

with an alias

Question 4

What are some examples of aggregate functions?

Answer 4

max( ) min( )
avg( ) sum( )
count( ) every( )

Question 5

What is the purpose of a group by clause?

Answer 5

perform a task on designated groups of rows