Please help me with this database relational algebra(for example, I need answer to have this format. "concat(Fname, Lname)->fullname,Bdate,Sex Super_ssn=333445555 (Employee)" questions refer to the table given below. Thank you

1) How many airports are in each state?

2) List all airlines that operate at Los Angeles International Airport (LAX)

Hint Use a union on the flight leg relation between departing and arriving flights

3) What is the least expensive flight number without restrictions. Show a single result using the appropriate math function (use Gamma operator).

4) List the name and phone number of all customers with a seat reserved on a flight that leaves Stockton airport (SCK) on January 28, 2018.

Hint Use the date function for your comparison date('2018-01-28') and use the reservation date

AIRPORT Airport code Name City State FLIGHT Flight_number Airline Weekdays FLIGHT_LEG Flight number Leg_number Departure_airport_code Scheduled_departure_time Arrival_airport_code Scheduled arrival time LEG INSTANCE Flight_number Leg_number Date Number_of_available_seats Airplane_id Departure_airport_code Departure_time Arrival_airport_code Arrival time FARE Flight_number Fare_code Amount Restrictions AIRPLANE TYPE Airplane_type name Max_seats Company CAN LAND Airplane type_name Airport_code AIRPLANE Airplane_idTotal_number_of_seats Airplane_type SEAT RESERVATION Flight number Leg_number Date Seat_number Customer_nameCustomer_phone AIRPORT Airport code Name City State FLIGHT Flight_number Airline Weekdays FLIGHT_LEG Flight number Leg_number Departure_airport_code Scheduled_departure_time Arrival_airport_code Scheduled arrival time LEG INSTANCE Flight_number Leg_number Date Number_of_available_seats Airplane_id Departure_airport_code Departure_time Arrival_airport_code Arrival time FARE Flight_number Fare_code Amount Restrictions AIRPLANE TYPE Airplane_type name Max_seats Company CAN LAND Airplane type_name Airport_code AIRPLANE Airplane_idTotal_number_of_seats Airplane_type SEAT RESERVATION Flight number Leg_number Date Seat_number Customer_nameCustomer_phone