Using the Solmaris Condominium Group Database from A Guide To SQL (9th Edition) solve the following, Solmaris Condominium Group would like to know the impact of discounting condo fees by 3 percent. Write a SQl statement in Oracle that displays the condo id, unit number, discounted condo fee, discounted condo fee with CEIL function and discounted condo fee with the FLOOR function. Will the values of the discounted condo fees vary? If so, use the condo with the ID of 1 to explain your answer

Schema:

?eject Browser ? ? c ?127.0.0.1:8080/apex/f?p-4500:1001 :3876258707458816:NO ORACLE Application Express Welcome SOL I Logout? Home Application Builder? SQL Workshop Hame S0L Workshop Object Browser Help Tatles Create ? APEXS ACL APEXS_WS FILES WS HSTORY APEXS WS LINKS APEXS WS NOTES APLXS_Ws ROWS APEXS WS TAGS APEKS WS WEBPG SECTIONS APEXS WS WEBPG SECTION H CONDO UNIT DEMO CUSTOMERS DEMO ORDERS DEMO ORDER ITEMS DEMO PRODUCT DEMO STATES DEMO USERS DEPT LOCATION SLRVICL CATLGORY Appication Lxpress 4.0 2.00.09 Wolapac SOL Usar sol Language en Copynght &1330, 2010, Crade All rihts eserved ?eject Browser ? ? c ?127.0.0.1:8080/apex/f?p-4500:1001 :3876258707458816:NO ORACLE Application Express Welcome SOL I Logout? Home Application Builder? SQL Workshop Hame S0L Workshop Object Browser Help Tatles Create ? APEXS ACL APEXS_WS FILES WS HSTORY APEXS WS LINKS APEXS WS NOTES APLXS_Ws ROWS APEXS WS TAGS APEKS WS WEBPG SECTIONS APEXS WS WEBPG SECTION H CONDO UNIT DEMO CUSTOMERS DEMO ORDERS DEMO ORDER ITEMS DEMO PRODUCT DEMO STATES DEMO USERS DEPT LOCATION SLRVICL CATLGORY Appication Lxpress 4.0 2.00.09 Wolapac SOL Usar sol Language en Copynght &1330, 2010, Crade All rihts eserved