1. Assume that you are given the following relational schema for an Airport

passengers (PassID: integer, FirstName: varchar(32), LastName: varchar(32), Birthdate: date, Address: varchar(128), Email: varchar(32), PhoneNumber: char(10), RewardPoints: integer, Citizenship: varchar(32), Gender: char(1))

Primay key: PassID

trips (TripID: integer, AirCraftID: integer, Capacity: integer, DeptTown: varchar(32), DeptDate: date, DeptTime: time, ArrTown: varchar(32), ArrDate: date, ArrTime: time, Fare: float(4,2))

Foreign key: AirCraftID references aircrafts(AircraftID)

Primary key: TripID

staff (StaffID: integer, FirstName: varchar(32), LastName: varchar(32), Birthdate: date, Address: varchar(128), Email: varchar(32), PhoneNumber: char(10), Gender: char(1), Salary: integer, DepartmentID: integer, HiredDate: date, PositionName: varchar(32))

Foreign key: DepartmentID references departments(DeptID)

Primary key: StaffID

pilots (PilotID: integer, FirstName: varchar(32), LastName: varchar(32), Birthdate: date, Address: varchar(128), Email: varchar(32), PhoneNumber: char(10), Gender: char(1), Salary: integer, HiredDate: date, Rating: integer)

Primary key: PilotID

aircrafts (AircraftID: integer, Name: varchar(32), NumSeats: integer, ManufacturedDate: date, LastServiceDate: date)

Primary key: AircraftID

departments (DeptID: integer, Name: varchar(32), Category: varchar(32))

Primary key: DeptID

booking (PassengerID: integer, TripID: integer, BookDate: date, BookTime: time)

Foreign key: PassengerID references passengers(PassID)

Foreign key: TripID references trips(TripID)

Primary key: (PassengerID, TripID)

works (StaffID: integer, DepartmentID: integer, Year: integer)

Foreign key: StaffID references staff(StaffID)

Foreign key: DepartmentID references departments(DeptID)

Primary key: (StaffID, DepartmentID)

flies (PilotID: integer, TripID: integer)

Foreign key: PilotID references pilots(PilotID)

Foreign key: TripID references trips(TripID)

Primary key: (PilotID, TripID)

services (ServiceID: integer, StaffID: integer, Staff2ID: integer, AirCraftID: integer, ServiceDate: date, Description: varchar(32))

Foreign key: StaffID references staff(StaffID)

Foreign key: Staff2ID references staff(StaffID)

Foreign key: AirCraftID references aircrafts(AircraftID)

Primary key: ServiceID

Make a query for the following question:

Show the first name, last name, and reward points of every distinct passenger who has booked a trip to "San Jose" and has reward points more than 2000. Show the results in asc order of reward points.