Office Locations
Analytics Teams
Team Trivia
Window Functions
SQL Statements
100

This city was named after the Territorial Governor of Kansas

What is Denver?

100

Sales Engineers are stakeholders of this pod.

GTM

100

This person loves concerts and has been to 44 concerts this year.

Jackie

100

The function that will return the value in the first row of the window frame

What is FIRST_VALUE()?

100

This uniquely identifies a row in a table.

What is a Primary Key?

200

This European capital's name comes from a barrier built across a river flowing through it

What is Amsterdam?

200

This pod just presented at the Coalesce conference.

Solutions

200

This person was a ballerina growing up.

Catherine

200
The technical term for the calculation resulting from using AVG() as a window function

What is a Moving Average or a Rolling Average?

200

This is the long form of the term 'SQL'

What is 'Structured Query Language'?

300

The only city in the world to have a natural saltwater lake within its city limits

What is Oakland?

300

This group defines the standards and processes for our team (must say the full name)

Center of Excellence

300

This person was once top 20 in the nation for a sport.

Danish

300

The function that adds ties to the RANK function

What is DENSE_RANK()?
300

The SQL statement is used to extract data from a database

What is SELECT?

400

This city hosted the Olympic Games in 1908, 1948 and in 2012, which is more than any other city

What is London?

400

This is our largest pod.

R&D

400

This person ran more miles in the past year than drove.

Matt

400

The function you'd use to get last week's value in this week's row

What is LAG()?

400

This is the long form of the term used to describe a WITH Clause

What is a "Common Table Expression"?

500

The river in this city is a popular surfing spot. Surfers ride a standing wave about 3 feet high.

What is Munich or München?

500

All members of this pod live in the East or South Bay.

Marketing

500

This person has taken circus classes, Silks and Lyra, for 6 years.

Charlotte

500

The part of the window function call that defines the rows used

What is the Frame clause?

500

A combination of two or more columns in a table used to identify a row in a table.

What is a Composite Key?

M
e
n
u