Answer this in SQL query.

$1.$ Return each email address and the number of corresponding bookings. Return an email only if it has less than $4$ corresponding bookings. This query should use a JOIN$-$based approach; you cannot use subselects.

$2.$ Return each flight number whose destination starts with the same letter as the destination of flight $\text{'}$BA$405\text{'}.$ Return the rows in their alphabetic order. Do not return flight $\text{'}$BA$405\text{'}.$ the query should use a JOIN$-$based approach; you cannot use subselect.

$3.$ Return the ID$,$ the first name, the last name of each person who booked at least one flight cheaper than $120$ dollars. return each person just once. you do not have any restrictions for this query.

$4.$ what is the position of flight $\text{'}$BA$1515\text{'}$ if you order the Bristish Airway $($BA$)$ flights by their duration in descending order? do not count the unknown values. return a single value and name the column as position. the query should use a subselect$-$based approach; you cannot join table.

$5.$ return the name of each airline that operates a flight to New York and Paris too. Order the names. This query should use a subselect$-$based approach; you cannot join tables.