Interview

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:

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:

x