Using the hoteldb schema, write SQL that will provide a list of Family Rooms and their prices. The output should have:

Hotel Name, Address, Room No, Type, Price

Please provide this in SQL. Hoteldb is the schema of the picture below.

Avalos 4025 x MySQU Workbench n Local instance MySQL 80 X Avalos 4025 (hoteldb) X Local instance MySQLBOX File Edit View Query Database Server Tools Scripting Help 6 NOI Query 1 Administration - Server Status 10 Limt to 1000 rows Navigator MANAGEMENT Server Status Client Connections Users and Privileges Status and System Variables Data Export Data Import/Restore 1 use hoteldb; 2. select from GUEST: INSTANCE Startup / Shutdown A Server Logs A Options File PERFORMANCE Dashboard Result Grid Fom Editor Administration Schemas Result Grid Fiter Rows: Edit: Export/Import: Wrap Cell Content: E guestNo name address city 1 John Doe 1 Main St Los Angeles 2 2 Mary Jane 199 Chambers St New York 3 Hankkim 27 Charles St London 4 Bob Jones 10 Burlington St London 5 Paul John 350 W 18th St Apt 3C New York 55 Ann Smith 203 E 20th St Apt 1A New York GUEST1 X Output 1 Action Output = Time Action Message 1 18 06 21 use hoteldo Orow(s) affected 2 18:06:21 select from GUEST LIMIT 0, 1000 16 rowis) retumed Apl Information No object selected Duration / Ferch 0.015 sec 0.000 sec /0.000 sec Object Info Session Ready HE Type here to search O . D 6:11 PM 2/26/2021 Tools Scripting Help OOI Limt to 1000 rows MySQU Workbench Avalos 4025 x File Edit View Query Database Server 5 80 80 Navigator Quinly SCHEMAS Fiter objects 1. ve hoteldb 2. Tables BOOKING E GUEST E HOTEL ROOM Views Stored Procedures Functions ETC use hoteldb; select * from GUEST; Administration Schemas Information > Schema: hoteldb Output Action Output Time Action Message Duration / Fetch Object Info Session HE Type here to search O A D l19 1:17 PM 2/27/2021