Santiago Moresi

Generation

text to sql syntaxWed, 05 Jul 2023

La ganancia neta por sucursal es las ventas menos los gastos (Ganancia = Venta - Gasto) ¿Cuál es la sucursal con mayor ganancia neta en 2019?

SELECT branch_name, SUM(net_profit) FROM branch WHERE year=2019 GROUP BY branch_name ORDER BY SUM(net_profit) DESC LIMIT 1;

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