Rank Campaigns by KYC Submission Rate

Read the full interview experience this question came from →

Quick Overview

Rank marketing campaigns by KYC submission rate in PostgreSQL. Practice three-table joins, conditional distinct aggregation, numeric rates, and dense ranking.

Rank Campaigns by KYC Submission Rate

Company: Airwallex

Role: Data Scientist

Category: Data Manipulation (SQL/Python)

Difficulty: medium

Interview Round: Technical Screen

Overview: Rank marketing campaigns by KYC submission rate in PostgreSQL. Practice three-table joins, conditional distinct aggregation, numeric rates, and dense ranking.

Read the full Airwallex Data Scientist interview experience this question came from

|Home/Data Manipulation (SQL/Python)/Airwallex
Airwallex logo
Airwallex
Aug 11, 2026
mediumData ScientistTechnical ScreenData Manipulation (SQL/Python)
6
0
Loading...
Loading comments...