Santiago Moresi

Generation

text to sql syntaxSun, 09 Jul 2023

Del total de clientes que realizaron compras en 2019 ¿Qué porcentaje lo hizo en al menos dos sucursales? (expresado en porcentaje y con dos decimales

SELECT 100 * SUM(CASE WHEN num_branch >= 2 THEN 1 ELSE 0 END) / COUNT(*) AS pct_multi_branch FROM ( SELECT COUNT(*) AS num_branch FROM purchases WHERE purchase_date >= '2019-01-01' GROUP BY customer_id ) sub;

Want to kickstart your project?Use the new AI Studio to create your code