Interview Guides

Interview Guides

Weekly Merchant Launch Metrics by City | Dataford Interview Questions

All questions/SQL & Data Manipulation

Asked 2mo ago|

Uber

Uber

Weekly Merchant Launch Metrics by City

Medium

Date FunctionsGroup ByAggregations

Problem

Task

You are asked to write a SQL query that pulls the key metrics for a new merchant launch by city and week. The output should show weekly launch performance for each city, including merchant counts and core activity metrics, using PostgreSQL-compatible SQL.

Problem

Task

You are asked to write a SQL query that pulls the key metrics for a new merchant launch by city and week. The output should show weekly launch performance for each city, including merchant counts and core activity metrics, using PostgreSQL-compatible SQL.

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Quora

Compare Sales Before Product LaunchMedium

Instacart

Measure Week-Over-Week Metric ChangesMedium

Uber

Compare Weekly Delivery Time by MarketHard