$3$rd level, Fall $2024$

Sheet $1$: SQL Revision practice

Question$1$: Write the right SQL statement that answers the following queries.

$1-$ Find the airports in a specific state $($e$.$g$.,$ 'California'$)$ that can accommodate

airplanes from a particular company $($e$.$g$.,\text{'}$XYZ Airlines'$).$

$2-$ Find the total number of seats available for a specific airplane $($e$.$g$.,$ 'Boeing $737\text{'}).$

$3-$ List all airports that can accommodate at least one airplane type.

$4-$ Find the airports in a specific state $($e$.$g$.,$ 'Texas'$)$ that have the word 'International'

in their names.

$5-$ Find the airplane types that can land at a specific airport $($e$.$g$.,\text{'}$JFK$\text{'}).$

$6-$ Find the total number of seats available at a specific airport $($e$.$g$.,$ 'LAX'$).$

$7-$ Find the names of airports and their respective cities in a specific state $($e$.$g$.,$ 'New

York'$).$

$8-$ Find the airplane types manufactured by a specific company $($e$.$g$.,$ 'Airbus

Industries'$).$