SQL 5.1.4

SELECT cinema_id,
    standard_seat_ticket*standard_ticket_price + vip_seat_ticket*vip_seat_ticket_price + virtual_seat_ticket*virtual_seat_ticket_price + senior_ticket*senior_ticket_price + adult_ticket*adult_ticket_price + child_ticket*child_ticket_price + discount_applied*standard_ticket_price as Total_Price
FROM seat_price
ORDER BY Total_Price DESC;