Stanford University interview questions

Please do the following – in your new spreadsheet: Please split date_of_reg into two columns, one with only the date (mm/dd/yy) and another one with only the time (hour:min:second). Given the information in payment_method, please calculate the total amount for Paypal only, the total amount for Venmo only, and the average amount of payment per participant. This sheet has some errors. For each type of error below, please list both the user_id(s) and contact_id(s). Please find duplicate participants that have the same user_id Please find duplicate participants that have the same contact_id How did you solve these duplicate tasks? Please briefly explain here.