Brightlane's fulfilment team is planning crate assignments for an incoming delivery. Each crate holds 8 items, and a batch of 275 items has just arrived. The team needs to know how many items will be left over after filling complete crates.
Write a query to return the number of leftover items in a single column named remaining_items.
Output:
- A single row with one column,
remaining_items, containing the leftover count.
Run previews · Check grades
Write a query, then run it to see results here.
Worked solution Try it yourself first
SELECT
275 % 8 AS remaining_itemsThe shape
The % operator returns the remainder of a division, so 275 % 8 answers the leftover question directly without ever computing the quotient.
Clause by clause
SELECT 275 % 8evaluates the modulo once and returns3. There's noFROMbecause the numbers come straight from the prompt as literals —275items,8per crate. Both operands are integers, so the result is the integer3, which is exactly the leftover count the fulfilment team needs.AS remaining_itemslabels the output column in the domain unit the team is working in. Without the alias, the column would land as?column?, which reads fine to whoever ran the query and uselessly to anyone looking at the result downstream.
Why this and not 275 - (275 / 8) * 8
The longer form recovers the same 3 by computing the quotient 275 / 8 = 34, multiplying back to 272, and subtracting from 275. Three operations, one of which depends on integer division behaving as truncation. The % operator is the single-operation shape SQL provides specifically for the remainder. It's shorter, it's harder to write wrong, and it reads as what it does.
You practiced using the modulo operator (%) to extract a remainder. The recurring shape: any time a quantity is divided into fixed-size groups and you need to know what's left over, % returns the remainder directly without computing the quotient first.
