PayPal Senior Data Scientist 1: SQL Round

I will list table schema and questions that were asked in the PayPal Job Interview for the role of Data Scientist 1 for the Bangalore location.

Question 1: Given a table containing information about bank deposits and withdrawals made using Paypal, write a query to retrieve the final account balance for each account, taking into account all the transactions recorded in the table with the assumption that there are no missing transactions.

Query 1:

Question 2: As a data scientist at PayPal, you have been asked to write an SQL query to analyze the transaction history of PayPal users. Specifically, management wants to know the average transaction amount for each user and how they rank based on their averages. For this task:

1. Calculate the average transaction amount for every user
2. Rank the users by their average transaction amount in descending order

Note: When the same average transaction amount is found for multiple users, they should have the same rank. The user with the next higher average transaction amount should be given the rank number that comes after the consecutive rank.