Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.