Task for 3 University Courses in MySQL

The task. When new projects are connected, it is usually necessary to calculate the metrics to correctly adjust the freed monitoring system based on the data of the already available 3 tables. You need to compile a SQL query to get a table with fields:

Project - Project ID and its name in one field through a point and gap. It is “15029. Overwatch is.”
Successful_transactions - The number of successful payments.
Successful_transactions_amount - The sum of successful transactions in the U.S.
• Average_check - The average check in the project in the U.S.
Max_amount_for_1_user - Maximum amount of payments for one user in a given period of time.
TOP3_most_popular_ps - the 3 most popular payment systems in the project by the number of successful payments.
TOP3_banks - the 3 most popular banks in terms of the number of successful payments.