Home Interview trainer SQL Of the customers who made a payment in… Of the customers who made a payment in March 2026, what percent also made a payment in April 2026? Return one number… SQL Level: Advanced Servicing and risk analytics
Of the customers who made a payment in March 2026, what percent also made a payment in April 2026? Return one number rounded to 1 decimal, aliased retention_pct. Month-over-month retention is a core loss-mitigation and servicing metric.
Table definitions (from the source exercise):
CREATE TABLE customers(customer_id INTEGER PRIMARY KEY, name TEXT, city TEXT, signup_date TEXT, credit_score INTEGER);
CREATE TABLE payments(payment_id INTEGER PRIMARY KEY, customer_id INTEGER, payment_date TEXT, amount REAL, method TEXT);
Hints Define one output row and the source-table keys. Check duplicates, NULLs and the order of filtering and aggregation. Answer Utbfobso: WEK mi uprpdcfe Pomtf hvgcia. Eost 121.3 lsnsi tm vyftl atr scysmn pvtum gockaipr Obwgk rtgemh / rhfkf ra Lawbe evcpnw. Th LE ymswicav wrcvep a INFU nhftl gwkb. Mpp ovfyye bdog IVDefp prec y PwKLB wtdmbuylrtuft vkfrr. Uuah kow daidfh opwmgheei dgt gndccip skddtvfbs; lhk cyohl nf dytgilwnp uh enycbyabr.
This answer is part of mentoring
Advanced questions come with a full breakdown and a mock interview with a working quant researcher. The first call is free.
Source and licence: SQL Practice Lab — Ebrahim Sharifi · MIT
Related questions For each customer with at least 2 payments, return customerid and their average number of days between consecutive payments, rounded to 1… Intermediate For each month (YYYY-MM) of payments, return the percent of payment DOLLARS that came in as cash, rounded to 1 decimal (cashpct), in… Intermediate Build a data-quality exceptions report with columns customerid, name, issuetype. One row per issue: 'missingscore' for customers with a… Intermediate Return the name of customers with a credit score below 650 who ALSO have at least one closed account. Combining a risk attribute with a… Intermediate Rank merchant categories by total spend (highest first) and add a running cumulative percent of all spend, rounded to 1 decimal (cumpct).… Intermediate Servicing teams track how long since each customer last paid. Using 2026-06-30 as "today": return customerid, their latest paymentdate,… Intermediate Work with a mentor 1:1 mentoring with a working quantitative researcher: a personal plan, weekly calls, code review and mock interviews. The first call is free.