Sobes.tech
Junior — Senior

Retrieving user transactions by phone number and amount limit

livecode

Task condition

Task: display the operation ID and its amount (operation_id, amount) for all records where the user has the phone +994555551234 and the operation amount exceeds 2 manats.

There are three tables in the database:

users with columns user_id, phone, name, age, email accounts with columns account_id, user_id, created_by, changed_by operations with columns account_id, amount, operation_time, operation_id