Payment Table: This table contains all the payment records on a date and member level. This is for members who make a payment on each day. A sample data looks like this Date 1/3 1/4 memberID S33.9 S19.3 $29.1 User Table: This table contains all the active records on a date and member level. This is for member who visit linkedin.com site on each day. A sample data looks like this: Date memberID 1/3 1/3 1/4 1/4 1/5 Date Table: this table contains the date information Date 1/2 1/3 1/4 1/5 1/6 Please write a query for the following cases: 1. Total Revenue & Payers: Create a table to display total revenue& number of buyers on each day Date buyers 2. Top payers: Create a table to display the top one payer on each day Date memberID 3. A distribution of # days active within a week: Create a table to show how many members are active for l day, 2days, 3days 7days during 31 . #Days Active | Count 4 4. Active but not payers: Create a table to display people who were active but did not pay on each day Date memberID