More Stats STAT
This is the midpoint center and is or is not sensitive to outliers.
What is the median?
What is the word people use when trying to remove errors from code?
What is debugging?
This SQL command is used to describe the layout of a table.
What is CREATE TABLE?
The process of combining two or more tables by finding rows in the tables that have identical values in matching fields
What is join?
It's the first rule of Fight Club
You do not talk about Fight Club.
This command creates a multi-line comment.
What is ''' Comment goes here '''
This operator lets you specify a range of values in a condition
What is BETWEEN?
A join in which all rows from the table on the right will be included, regardless of whether they match rows from the table on the left
What is right outer join?
"I'm going to make him an offer he can't refuse."
What is "The Godfather?"
An observation that lies outside the overall pattern of a distribution.
What is an outlier?
It is used for remainder division on integers, typically, but in Python can be used for floating point numbers.
What is % (modulo)
You can assign a name to a computed column by following the computation with this word and the desired name.
What is AS?
What is right outer join?
What is MINUS?
The name of the first movie in the Indiana Jones series. (Hint: Does not have Indiana Jones in the title)
What is Raiders of the Lost Ark?
This rule states 68%, 95%, and 99.7% of the data lie inside the first, second, and third standard deviations, respectively, for an approximately normal distribution.
What is the empirical rule?
What TV show/comedy group is python named for?
Who is Monty Python?
The major sort key immediately follows these words.
What is ORDER BY?
Operator that creates a temporary table containing every row that is in either the first table, the second table, or both tables
What is the UNION?
A high school wise guy is determined to have a day off from school, despite of what the principal thinks of that
What is Ferris Bueller's Day Off?
The average of the squared differences from the Mean.
What is variance?
A function that returns the length of a list.
What is len?
SQL includes these special functions to calculate sums, averages, counts, maximum values, and minimum values. (These functions apply to groups of rows.)
What are aggregate functions?
The SQL command used to ensure that only unique values are allowed in a non-primary key column
What is CREATE UNIQUE INDEX?
A chronicle of the early days of James T. Kirk and his fellow USS Enterprise crew members.
What is Star Trek?