Square/CashApp Data Analyst SQL interview questions 2023

Data Analyst Interview. (Generated with StableDiffusion)

The first round of interview for a Data Analyst/Data Scientist/Decision Scientist position at Square/Block/CashApp is a SQL pair programming exercise. This is a live interview where you will be presented with 2 tables of data and you’ll have approximately an hour to answer 4–5 questions.

You will write and compile code in a collaborative IDE called CoderPad. You only have the option of working in PostgreSQL, but don’t worry if you are used to a different flavor of SQL, you are able to use Google to search for anything you want, so i was able to lookup syntax differences.

You are presented with two Tables:

1. Customers — This table has information about customers.
a. customer_id: Unique identifier for a customer
b. created_at: Timestamp when the Account was created
c. state: Geographical state of the Customer.

Customers Table

2. Payments — This table has information regarding transactions between different customers.
a. payment_id: Unique id for a payment transaction
b. sender_id: Unique id of the sender of a transaction
c. recipient_id: Unique…