Santiago Moresi

Generation

text to sql syntaxThu, 06 Jul 2023

Del total de clientes que realizaron compras en 2019 ¿Qué porcentaje lo hizo en al menos dos sucursales? Tabla 'cliente', 'compra'

SELECT ROUND(COUNT(*)/(SELECT COUNT(*) FROM cliente WHERE cliente.id_cliente IN (SELECT id_cliente FROM compra WHERE YEAR(fecha_compra)=2019))*100,2) AS 'Por_dos_sucursales' FROM (SELECT id_cliente FROM compra WHERE YEAR(fecha_compra)=2019 GROUP BY id_cliente HAVING COUNT(DISTINCT id_sucursal)>=2)

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