Customers Exceeding Their Plan
Medium
Telecom Usage
Return customers whose usage exceeds the included minutes of their plan, with usage and included minutes. Order by customer.
Table schema
Calls(id INT PRIMARY KEY, customer VARCHAR(10), minutes INT, call_date DATE)
Plans(customer VARCHAR(10) PRIMARY KEY, included_minutes INT)Sample data
Calls
id | customer | minutes | call_date
1 | Ann | 30 | 2026-04-01
2 | Ann | 50 | 2026-04-02
3 | Bob | 20 | 2026-04-01
4 | Cy | 70 | 2026-04-03
5 | Cy | 45 | 2026-04-04
6 | Bob | 15 | 2026-04-05
Plans
customer | included_minutes
Ann | 100
Bob | 30
Cy | 100
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.