Create View_BMS in SQL
Question: Create View_BMS Create view as user_travel_details which include their id, name, source and destination and display column as user_id, user_name, source and destination respectively . Code: Main.sql Recommended:
SQL
Fetch Resort Details in SQL
Question: Fetch Resort Details Write a query to display the resort name and its manager name for resort located at “JAIPUR”. Sort by resort name . Code: Main.sql Recommended:
Review Comment for all Resort in SQL
Question: Review Comment for all Resort Write a query to display the resort name , guest name , review comments for all resort. sort the output in ascending order of resort ID. Code: Main.sql Recommended:
Review Comment for star rating Resort in SQL
Question: Review Comment for star rating Resort Write a query to display resort id and review comments of all resort which has star rating above 4.2. sort the output in ascending order of resort id. Code: Main.sql Recommended:
Resort that charges the highest in SQL
Question: Resort that charges the highest Write a query to display the name of the resort that charges the highest. Sort the output on the resort name. Code: Main.sql Recommended:
Cities having Summer Temperature More than Jaipur in SQL
Question: Cities having Summer Temperature More than Jaipur Write a query to display all the town names which has summer temperature more than “JAIPUR”. Output should be sorted on town name. Code: Main.sql Recommended:
PointOfInterest Locations in Chennai in SQL
Question: PointOfInterest Locations in Chennai Write a query to display the pointId, description, open time and close time for all the pointofinterest in “CHENNAI” location. Output should be sorted on pointid. Code: Main.sql Recommended:
Resort with Least Capacity in SQL
Question: Resort with Least Capacity Write to query to display the name and town name of the resort that has least bed room count. Sort the output on the resort name. Code: Main.sql Recommended:
Guest who paid highest charges in SQL
Question: Guest who paid highest charges Write a query to display the guestid and guest name who was charged highest amount in the resort. Sort the output on the guestid. Code: Main.sql Recommended:
Guest details and Total Charges paid in SQL
Question: Guest details and Total Charges paid Display guest details who paid total charges RS.50000 and above. Write a query to fetch Guest id, Guest name and Sum of total charges. Give alias name to total charges as TOTALPAID. Sort the result by guest id. Code: Main.sql Recommended: