Santiago Moresi

Generation

text to sql syntaxFri, 14 Jul 2023

Del total de clientes. Qué porcentaje realizó compras sólo por el canal online entre 2019 y 2020

SELECT ((SUM(CASE WHEN canal='online' THEN 1 ELSE 0 END))/(SELECT COUNT(*) FROM customers))*100 as online FROM customers;

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