Writing a ROLLUP Query

Harbr's operations team wants a single summary of shipment outcomes across all regions — how many shipments were ON_TIME, DELAYED, or FAILED - with regional subtotals and a company-wide grand total in one result set. Rather than running separate queries per region, you'll use ROLLUP on logistics.shipments to produce the full breakdown in a single pass. Your task is to build that query and identify the total number of FAILED shipments recorded across all regions.

⚠️ Can't select a database, or getting a "table not found" error?

Use the table's full path in your FROM clause. Get it from the left panel: Databases tab → expand your COURSE_… database → select the table → Copy name.