Daily counts of pre-purchased lunches and lunches charged to prepaid student accounts. Total value is calculated at $6 per lunch.
| Date | Pre-purchased lunches | Lunches charged to prepaid account | Total lunches | Total value of served meals ($6 each) |
|---|
Pre-purchases are counted by the selected lunch date. Prepaid-account charges are counted by transaction date (created_at); the transaction table has no separate lunch_date field. The two counts are added together as requested; the value column is total lunches multiplied by $6.