Excel: 1 How many transactions tagged as VPN happened in September. Present the data in pivot 2 What are the top 10 appearing IPS. Present the list 3 How many fraud conversions were tracked during September 2020 and which advertisers were affected? Please present the data in the pivot 4 How many transactions come from web advertisers vs in app advertiser. Please present the results in a pie chart. 5 How many conversions happened after 3, 7, 20 days ( conversion happens after the click). Present the data in pivot 6 What is the chargeback ratio ( % of claimed revenue from overall spend) per months appearing in tab "Overall spend" ? Please present the results in a table Below you will find four tables from a sample schema, containing some data tracked in our platform. Basing on them please write queries to answer the following questions: 1. Query to filter the results and receive only conversions there the condition ‘fraud’ is YES. Include columns about ‘supply_payout_usd’, ‘client_id’, and ‘client_name’. 2. Create a table containing columns and corresponding information about: - sum of ‘advertiser_spent_usd’ and sum of ‘supply_payout_usd’ - ‘app_id’, ‘app_name’, ‘client_id’, ‘client_name’ - ‘advertiser_id’ and ‘advertiser_id’ columns for ‘campaign_id’ 1401130.