After increasing the condo fee of each large condo by $150

Question:

After increasing the condo fee of each large condo by $150 (Exercise 3), Solmaris decides to decrease the condo fee of any condo whose monthly fee is more than $750 by one per cent. Update the condo fees in the LARGE_CONDO table accordingly.

Answer:

UPDATE LARGE_CONDO

SET CONDO_FEE = CONDO_FEE + (CONDO_FEE / 100)

WHERE CONDO_FEE > 750.00;
Click to Rate This Answer!
[Total: 0 Average: 0]

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.