What Cities View and Buy
What Cities View and Buy
L. is checking how product interest turned into purchases across different cities. For each city, separately count product_view and purchase events, using a condition-based counter for each metric.
Output city, the number of views as views and the number of purchases as purchases. Sort the result by city.
Any row order
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid