Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement