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.

Qualquer ordem de linhas

PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid