Count Bottles and Cans Across Pallets

Problem

Table: `pallet`

| Column Name | Type |
|---|---|
| pallet_id | int |
| crate_id | int |
| bottle_qty | int |
| can_qty | int |

`pallet_id` is the primary key. A pallet holds some loose bottles and cans (`bottle_qty`, `can_qty`) and may optionally hold one crate identified by `crate_id` (NULL if the pallet has no crate).

Table: `crate`

| Column Name | Type |
|---|---|
| crate_id | int |
| bottle_qty | int |
| can_qty | int |

`crate_id` is the primary key. A crate holds its own bottles and cans.

Report the total number of bottles and cans across **all** pallets, including the contents of any crate sitting on a pallet. Output two columns aliased `bottle_qty` and `can_qty`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns bottle_qty, can_qty.

Starter code (SQL)

SELECT *
FROM pallet;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium