Using the Colonial Adventure Tours Database from A Guide To SQL (9th Edition), Create a trip cost view that groups the trips by their cost. Produce a count of trips for each particular price, sorting them in ascending order by price. Could you update the underlying table(s) in the view? Why or why not?

Schema:

?eject Browser ? 127.0.0.1:8080/apex/f?p-4500:1001 :3654456629742387-NO::: ORACLE Application Express Welkome COLONIAL ADVENTURE Logout Application Builder? SQL Workshop Hame S0L Workshop Object Browser Create ? APEXS ACL APEXS_WS FILES WS HSTORY APEXS WS LINKS APEXS WS NOTES APLXS_Ws ROWS APEXS WS TAGS APEKS WS WEBPG SECTIONS DEMO CUSTOMERS DEMO ORDERS DEMO ORDER ITEMS DEMO PRODUCT DEMO STATES DEMO USERS HTMLDE PLAN TABLE RESLRVATION TRIP_GUIDES Appication Lxpress 4.0 2.00.09 Wolapac COLONIAL ADVENTURE Uaer COLONIAL ADVENTURF Language en Copynght &1330, 2010, Crade All rihts eserved