Answer to Question #250149 in Databases | SQL | Oracle | MS Access for Bonnie

Question

Management of the events have decided to allow a 10% discount on all events that cost over R 250. Create a PL/SQL query to display the event name and price, with or without the applied discount. 

Sample Results Open Air Comedy Festival price: R 270 ------------------------------------------------------- Mountain Side Music Festival price: R 252 ------------------------------------------------------- Beach Music Festival price: R 195 -------------------------------------------------------

Answer 1

SELECT name, price 
FROM items
WHERE price >250
ORDER BY price DESC, name;