How to create a competent SQL query?

Question

SQL

Greetings people .. I understand the stupid question, but everyone was once a beginner ..
In general, I am making a payment processing form, you need to make a request like this:
After the payment, in the "history" table, the value of the "ym" field changed to 1 ,
The most important thing is that this value changed only for the user who made the payment.
ps The user ID is stored in the history table, in order to recognize it, the handler needs to be pulled out of the email field,
I will explain, There is a history page where the user needs to pay for the order, he enters the history and confirms the payment for the order (a unique number is assigned to this order), the handler asks to enter an email user, the user enters it, after the user pay, the process above should occur.