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