Manipulation
What clause do we use to query data from a table?
SELECT
_______ ________ combine multiple rows together to form a single value of more meaningful information.
Aggregate Functions
What two operators are used to combine multiple conditions in a SQL query?
AND and OR
What clause do we use when we want to combine two or more tables?
JOIN
This constraint can be used to uniquely identify the row.
PRIMARY KEY
What clause would we use to add a new row to a table?
INSERT INTO
What aggregate function adds all of the values in a column and returns the result?
SUM()
This clause allows columns or tables to be aliased, which means specifically renamed in the returned result set.
AS
________ is the default JOIN and it will only return results matching the condition specified by ON.
INNER JOIN
This constraint assigns a default value for the column when no value is specified
DEFAULT
What statement should we use to make a new table called contact_info?
CREATE TABLE contact_info
What aggregate function returns the mean of all values in a column?
AVG()
The _____ clause is used to narrow a result set to a specified number of rows.
LIMIT
A _______ is a reference in one table's record to the primary key of another table.
FOREIGN KEY
This constraint can be used to ensure that each row has a distinctive value within this column, none can be repeated.
UNIQUE
What clause would we use to edit a specific row within a table?
UPDATE
What aggregate function do we use to return the largest value in a column?
MAX()
______ is a popular command that lets you filter the results of the query based on conditions that you specify.
WHERE
This clause stores the result of a query in a temporary table using an alias.
WITH
This constraint specifies that columns must have a value.
NOT NULL
What clause would we use to make a change to an existing table?
ALTER TABLE
What clause is used with aggregate functions to organize multiple rows of data by one or more columns?
GROUP BY
What clause would we use to sort selected results by a specific parameter?
ORDER BY
This will combine rows from different tables even if the join condition is not met
OUTER JOIN
You can only define one ________ constraint per table, which is sometimes confused with the _______ constraint, which can be used for multiple columns within a table, to define that no two rows can share the same value for that column.
PRIMARY KEY & UNIQUE