Filtering, Sorting & Business Queries
Define a business population, handle missing values and build an ordered extract you can explain.
Reference collection · v1.0Open collection →Read deeply.
Put your understanding to work.
Explore a topic as a collection of learning resources. Choose a chapter, work through a question, inspect the data or return to an explanation.
Explore the SQL reference collection →201 topic collections. Page 1 of 17. Existing companions are not automatically complete study units.
Count completed orders and reconcile sales
SQL practice · Retail case · 15–20 minutes. Start with retail-setup.sql in a disposable local SQLite database.
Existing companion · depth review pendingOpen collection →Compare two complete months
SQL practice · Retail case · 15–20 minutes. Start with retail-setup.sql in a disposable local SQLite database.
Existing companion · depth review pendingOpen collection →Calculate channel share with a common denominator
SQL practice · Retail case · 15–20 minutes. Start with retail-setup.sql in a disposable local SQLite database.
Existing companion · depth review pendingOpen collection →Find average order value at order grain
SQL practice · Retail case · 15–20 minutes. Start with retail-setup.sql in a disposable local SQLite database.
Existing companion · depth review pendingOpen collection →Rank completed orders reproducibly
SQL practice · Retail case · 15–20 minutes. Start with retail-setup.sql in a disposable local SQLite database.
Existing companion · depth review pendingOpen collection →Keep excluded records visible
SQL practice · Retail case · 15–20 minutes. Start with retail-setup.sql in a disposable local SQLite database.
Existing companion · depth review pendingOpen collection →Use SUMIFS with an explicit status
Excel practice · Use the supplied CSV with headers in row 1. Formulas use English function names and commas; your locale may use translated names or semicolons.
Existing companion · depth review pendingOpen collection →Count completed Web orders
Excel practice · Use the supplied CSV with headers in row 1. Formulas use English function names and commas; your locale may use translated names or semicolons.
Existing companion · depth review pendingOpen collection →Build a reconciled PivotTable
Excel practice · Use the supplied CSV with headers in row 1. Formulas use English function names and commas; your locale may use translated names or semicolons.
Existing companion · depth review pendingOpen collection →Calculate growth without confusing percentage points
Excel practice · Use the supplied CSV with headers in row 1. Formulas use English function names and commas; your locale may use translated names or semicolons.
Existing companion · depth review pendingOpen collection →Reconcile inventory counts
Excel practice · Use the supplied CSV with headers in row 1. Formulas use English function names and commas; your locale may use translated names or semicolons.
Existing companion · depth review pendingOpen collection →One useful next step
Start learning. Build understanding.
Explore the introductory learning, then create a free account to continue, save learning notes and track supported lessons. Registration and email verification cost nothing.