Junior — Senior
Selection of employees with total payments exceeding a specified threshold
livecode
Task condition
There are two tables: Person, containing information about employees, and Payments, where their monthly payments are recorded. A query is required that returns the employee's name and the total amount of payments if the total payout exceeds a specified value N.