Given the following relations: Booking(agent: String, tra…
Given the following relations: Booking(agent: String, traveler ssn: integer, trip id: integer) GoesOn(ssn: integer, id: integer) Leg(Trip id: integer, startLocation: String, endLocation: String, startDate: Date, endDate: Date) Owns(ssn: integer, passport number: integer, country: String) Passport(passport number: integer, country: String, expirationDate: Date, holderName: String) TravelAgent(name: String, years experience: integer, phone: String) Traveler(name: String, ssn: integer, dob: Date) Trip(id: integer, start location: String, end location: String, start date:Date, end date: Date) Show the SQL queries for the following questions (2 points each): 1) List the names of travelers who have not booked any trips. 2) List trip details booked by agents with at least 10 years of experience. 3) Retrieve the names of travelers who have traveled to at least two different destinations. 4) List the names of travelers who do not have a passport.
Read Details