SQL SQL
What does SQL stand for
How many US PROD DAGs do we have in Astronomer
66 DAGs!
What year was Paytronix Founded
2001
What retail giant once had a predictive analytics algorithm that told a teenager’s family she was pregnant—before she told them?
Target
True or False: “123456” has consistently ranked in the top 5 most common passwords for over a decade.
TRUE
What year did SQL first appear?
1973
How many active Fivetran connectors do we have?
109
What is the average lift in guest spending Paytronix claims for optimized targeted campaigns?
10–30%
What fast food chain lost millions due to a bug in its delivery promo system that doubled discounts instead of applying one?
DoorDash in 2019
Which country once tried to ban Excel charts in government reports after a major error?
The United Kingdom
What’s the difference between COUNT(column_name) and COUNT(*)?
COUNT(*) counts all rows (including NULLs!)
How many Nodes do we have in total in Coalesce
1117
How many transactions has Paytronix processed
Over 40 billion!
What U.S. state accidentally released every Social Security number of its residents in a 2006 database dump?
Texas
What is the real-world consequence of Amazon’s 1-click purchase button being patented for nearly 20 years?
Other e-commerce sites had to avoid implementing instant checkout
What will NULL + 5 return in SQL?
NULL
What warehouse has been the most expensive Year to date in Snowflake and for fun how much has it cost so far?
LOOKER_WH @ ~$48k
What are the busiest 2 days for Online Ordering
Super Bowl and Valentines Day
What fast food chain introduced a data-driven campaign that got canceled when AI started writing offensive tweets?
Burger King
What absurd “fix” did a U.S. city apply to prevent AI camera ticketing errors during winter?
Taped cardboard over all the sensors (to block snowflake-triggered tickets)
What’s inefficient about this Snowflake query:
SELECT * FROM huge_table WHERE TO_CHAR(created_at, 'YYYY-MM-DD') = '2024-01-01';
Applying a function to created_at column disables partition pruning → causes full scan
Without checking, what is our Snowflake US PROD account identifier?
WP45367
Which Px Merchant has the most accounts in Account_Summary
Jimmy John's with >47 million
What major airline’s meltdown in 2022 was caused in part by over-reliance on Excel and manual scheduling?
Southwest
What percent of enterprise data is estimated to be unused or “dark”?
80-90%