SQL GAME SHOW

TABLE BASICS

100

Structured Query Language

What is SQL?

200

A unique identifier(employee id, or SSN, etc..)

What is A PRIMARY KEY?

300

It's a key field(Column) in a database table, which relates the table to another table where the key is a primary key.

What is A FOREIGN KEY?

500

It is used to rename a table or column. The renaming of the table or column is temporary and does not change the actual name of the table in the database. More efficient programming; less keystrokes required

What is Aliases?

STATEMENTS

100

This statement is used to filter your SQL query

What is the WHERE Statement?

200

COLUMN NAMES OR "*"

What is followed after writing THE SELECT STATEMENT IN AN SQL QUERY?

300

SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

What are the six main clauses of a SQL statement?

400

The keyword used to retrieve unique records in specified Columns?

What is The "DISTINCT" Keyword?

500

The acronym CTE stands for

What is a Common Table Expression?

WHERE

100

This SQL keyword is used to filter rows based on a specific condition.

What is WHERE?

200

When using the WHERE clause, this comparison operator is used to check if a value is greater than or equal to another.

What is >= (Greater Than or Equal To)?

300

used to combine multiple filter conditions in the WHERE clause

What is AND?

400

used to filter rows where a specific column has no value

What is NULL?

500

In a WHERE clause, this logical operator is used to exclude rows that meet a specified condition.

What is "NOT"?

SELECT

100

All columns in a table are represented by this symbol in a SELECT statement.

What is *?

200

This SQL keyword is used to arrange the result set in ascending order.

What is ORDER BY?

300

In a SELECT statement, this SQL function is used to count the number of rows.

What is COUNT()?

400

When using SELECT DISTINCT, this is being excluded from the result set.

What are duplicate values?

500

In a SELECT statement, this SQL function calculates the average value of a numeric column.

What is AVG()?

JOINS

100

It allows you to link data from two or more tables together into a single query result

What is a Join?

200

Returns all rows from the left table, and the matching rows from the right table. The result is NULL from the right side, if there is no match.

What is a LEFT JOIN?

300

return all rows from the table in the right table and only matching rows from the table in the FROM clause

What is RIGHT JOIN?

400

a method of combining two or more tables so that the result includes unmatched rows of one of the tables, or of both tables

What is OUTER JOIN?

500

Compound query operator used to combine the results of 2 select statement without duplicating rows

What is UNION?