Consider the following three relations:

TRAVEL_AGENT (name, age, salary) CUSTOMER (name, departure_city, destination, journey_class) TRANSACTION (number, cust_name, travel_agent_name, amount_paid)

Write SQL statements to answer the following questions.

1. Display the names and salaries of all travel agents who did not arrange journeys for customer John Smith, in ascending order of salary.

2. Display the names of travel agents who have five or more transactions.

3. Display the names of all travel agents who have arranged at least ten journeys to Ottawa.