SQL queries - 2025 ACF Nationals

Tossup

Execution of these statements may invoke the spool operator to store intermediate results. Data transmission is reduced when applying predicate pushdown to these statements. RBOs use heuristics while CBOs use static cost models to optimize these statements. Including a covering index within these (-5[1])statements guarantees that they can perform an index-only scan. (10[1])The namesake execution plan of these statements (10[1])may be viewed and analyzed using the (10[1])EXPLAIN (10[1])keyword. Window (10[1])functions within these statements are contrasted with their aggregate functions. (10[2])Edgar Codd (10[1])created a system used to formally model the semantics (-5[1])of these statements called the relational algebra. (10[1])These statements often contain JOIN (10[1])clauses (10[4])and begin with the SELECT (10[2])keyword. (10[2])For 10 points, name these statements used to interact with database tables. (10[1])■END■ (10[2])

ANSWER: SQL (“sequel”) queries [or SQL queries; accept SQL statements/expressions/scripts; accept Structured Query Language or specific dialects such as MySQL or PostgreSQL in place of “SQL”; accept SELECTs until read; prompt on expressions or scripts alone by asking “In what language?”; reject any non-database queries, such as “web queries”]

= Average correct buzz position

Answerline and category may not exactly match the version played at all sites

Back to tossups

Buzzes

Player	Team	Opponent	Position	Value
Ryan Sun	UC Berkeley B	Virginia Tech	42	-5
Rasheeq Azad	North Carolina A	Ottawa	51	10
Liam Kusalik	Waterloo A	Cornell A	58	10
Geoffrey Wu	Columbia A	Minnesota	65	10
James Ah Yong	Waterloo B	UC Berkeley A	66	10
Thomas Tibbetts	UCF	Stanford	68	10
Nathan Sheffield	MIT	Illinois B	78	10
Charles Hang	WUSTL A	Cornell B	78	10
Matthew Wang	British Columbia	Toronto B	80	10
Skand Parvatikar	Arizona State	Columbia B	89	-5
Leo Law	Florida	Iowa State	96	10
Adam Fine	Chicago A	Michigan	101	10
Ani Perumalla	Penn State	Chicago B	102	10
Alex Akridge	Indiana	Yale	102	10
Jeffrey Xu	Georgia Tech	North Carolina B	102	10
Aum Mundhe	Rutgers	Toronto C	102	10
Amogh Kulkarni	Georgia State	Ohio State	107	10
Cade Reinberger	RIT	Illinois A	107	10
David Bass	Johns Hopkins	Northwestern	108	10
Garrett Buryska	Winona State	WUSTL B	108	10
Isaac Mammel	Maryland	Vanderbilt	120	10
Derek Chen	Columbia B	Arizona State	121	10
Orion Keller	Virginia Tech	UC Berkeley B	121	10

Summary

Tournament	Exact Match?	TUH	Conv. %	Power %	Neg %	Average Buzz
2025 ACF Nationals	Yes	21	100%	0%	10%	92.43