Sobes.tech
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.