Avenue connects to companies' Data Warehouses and alerts and built with SQL. A lot of the onboarding, expansion, and support work boils down to helping our customers understand their (often messy) data, build metrics, create alerts, etc.
Customer Engineering @ Avenue
Please answer the following questions with SQL solution along with a 1-3 sentence description. Submit your answers, in any format, to firstname.lastname@example.org
Assume you have the below tables on user actions. Write a query to get the active user retention by month.
string ("sign-in", "like", "comment")
Assume you are given the below tables for trades and users. Write a query to list the top 3 cities which had the highest number of completed orders.
string (e.g. "NFLX", "FB", etc.)
string ("buy", "sell")
string ("complete", "cancelled")
Assume you have the below events table on app analytics. Write a query to get the click-through rate per app in 2019.
Assume you are given the below table for spending activity by product type. Write a query to calculate the cumulative spend for each product over time in chronological order.
Assume you have the below tables on sessions that users have, and a users table. Write a query to get the active user count of daily cohorts, i.e. the counts of users registered each day.