Santiago Moresi

Generation

text to sql syntaxThu, 06 Jul 2023

total de clientes del 2019, cual es el porcentaje lo hizo en al menos dos sucursales. Tablas 'clientes', 'compras'.

SELECT COUNT(*) AS total_clientes, 100*COUNT(DISTINCT p.sucursal)/COUNT(*) AS porcentaje FROM clientes AS c LEFT JOIN compras AS p ON c.id_cliente = p.id_cliente WHERE YEAR(c.fecha_cliente) = 2019;

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