MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;


@@version


8.0.27


CREATE TABLE hotel(
  id INT,
  precio_habitacion INT,
  dias INT,
  numero_huespedes INT
);
INSERT INTO hotel(id, precio_habitacion, dias, numero_huespedes)
VALUES
(501, 350000, 3, 5),
(502, 250000, 2, 3),
(503, 180000, 1, 5),
(504, 290000, 6, 7);
SELECT id, SUM(precio_habitacion * dias) + SUM(numero_huespedes * 50000) AS Costo
FROM hotel
WHERE numero_huespedes > 4
GROUP BY id;


id
Costo


501
1300000

503
430000

504
2090000