Santiago Moresi

Generation

text to sql syntaxFri, 14 Jul 2023

Del total de clientes que realizaron compras en 2020. Que porcentaje lo hizo en una sola sucursal. Teniendo tabla, compra, sucursal, cliente

SELECT sum(case when num_sucursales=1 then 1 else 0 end)/count(*)*100 as porcentaje from ( select count(distinct sucursal) as num_sucursales from compra c join sucursal s on c.id_sucursal=s.id join clientes cl on c.id_cliente=cl.id where year(c.fecha)=2020 group by c.id_cliente ) q;

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