SQL, Perl, and Project Management
What type of SQL function, such as RANK() or LAG(), performs a calculation across a set of table rows that are related to the current row?
Window Function
Which item did Susan famously champion as the most important item to save from Katie’s broken fridge?
Mayo
Which county was the first to be converted in California?
San Mateo
This logical paradox from ancient Greece argues that for an object to move, it must change its position. However, at any given instant, it occupies a single spot. Since it cannot be in two places at once, it must be at rest at every instant, meaning motion is impossible.
Zeno’s Arrow Paradox
On "The Bachelor," the Bachelor gives what flower to contestants whom he wants to stick around for the next episode?
Rose
What is the community-managed central repository for perl modules?
Which DC team member is commonly known as an ‘instigator’ at Summer Company Meeting social events?
Dan
What year was Payment Express launched?
2009
Solve this word puzzle
Forgive and forget
Which two NFL teams are tied for the most superbowl victories?
Patriots and Steelers
What is the name of this three-character operator < = >, which is also known as the spaceship operator, and returns either -1, 0, or 1?
Combined Comparison Operator
How many DC team members previously worked for Epic?
What is the name of the private equity firm that recently invested in GSG?
Welsh, Carson, Anderson & Stowe
Without looking online, based on the 2020 census, list these cities in order of most to least populous - Chicago, Jacksonville, Los Angeles, Seattle, Charlotte
Los Angeles, Chicago, Jacksonville, Charlotte, Seattle
What is the family of oscine passerine birds that contains the crows, ravens, rooks, magpies, jackdaws, and jays?
Corvids
What is the risk response strategy involving acknowledging a project risk but taking no action unless the risk occurs, and it is most suitable for low-priority risks?
Active Acceptance (or Passive Acceptance)
How many DC team members have lived outside of the United States?
5
What was the first FL county to be converted?
Osceola
Without using a calculator, what is 30% of 546? (You can round up to avoid decimal points)
164
What ingredients go into the cocktail, a boulevardier?
Typically, whiskey, sweet vermouth, and campari
What is the name of the project management model, also known as the Iron Triangle, which shows the relationship between a projects three primary risks: Scope, Time, and Cost?
Triple Constraint
How many DC team members live in the Pacific Time Zone?
Two
Since DC has started tracking stubs, how many counties have gone live with 0 stubs?
Lee, Clay, Bay, Hernando - 4
Mad Gab - Decipher these words into a common phrase: “Canoe Key Pass Egret”
"Can you keep a secret?"
Name one of the two countries that is landlocked, and is also completely surrounded by other landlocked countries:
Liechtenstein or Uzbekistan