how can I write this query without create a new table

I create tables and insert the info into it as show in photo

this is the query and I need solution

- List name and phone number for each customer whose flight date is 1-1-2023.

- List all morning flights legs.

- List all airplane types that can land in Riyadh.

schedule dep. time Airport loand (@0i) data22 AIRPLANE_TYPE Columns Data Model |Constraints | Grants | Statistics | Triggers Sort.. | Filter: Columns Data Model |Constraints | Grants | Statistics | Triggers | Flashback | Dependencies |Details |Partitions | Ind 2 | Sort.. | Filter: (goi) data22 LAND Columns Data Model |Constraints | Grants |Statistics |T Sort.. | Filter: \begin{tabular}{|l|l|l|} \hline & \{ LAND_AIR_CODE & LAND_AIR_NAME \\ \hline 1 & LAX & A320 \\ \hline 2 & LHR & A320 \\ \hline 3 & LHR & 737 \\ \hline 4 & ORD & A320 \\ \hline 5 & LAX & 777 \\ \hline 6 & LAX & 737 \\ \hline 7 & ORD & 737 \\ \hline 8 & LAX & 787 \\ \hline \end{tabular} data 22 SEAT Columns Data Model | Constraints | Grants | Statistics | Triggers | Flashback |Dependencies |D Sort.. | Filter