How can i calculate a table and create a query with 4 different calculation in single column
<p>My question is : Management is proposing to increase the price of movies based on their rating using the following percentage scale: </p>

<pre><code>‘14A’, 25%; 
‘18A’, 15%; 
‘A’, 10%; 
all others 5%. 
</code></pre>

<p>Create a list that displays the movie name, rating type, current rental amount and revised rental amount. Column headings should be ‘Movie Name’, ‘Rating’, ‘Current Rental Price’, ‘New Rental Price’. The current and new rental prices must be formatted as currency with 2 decimal positions. Sort the list by rating. If there is more than a single movie in a category then sort by the movie name as a secondary sort.</p>

<pre><code>SELECT Name AS "Movie Name", Rating, RentalAmount AS "Rental Amount",  
           TO_CHAR(RentalAmount * 1.25, '999.99') AS "Revised Amount"  
FROM Movies  
ORDER BY Rating , Name;
</code></pre>