Write SQL to find users who ONLY take rides to or from airports (or who ONLY upload photos). Asked in the data modeling stage. For this exercise, use the rides interpretation and recognized airport codes.
user_id and full_name.user_id ascending.| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique user identifier |
| full_name | VARCHAR(100) | User display name |
| Column | Type | Description |
|---|---|---|
| ride_idPK | INT | Unique ride identifier |
| user_id | INT | User who took the ride |
| pickup_airport_code | VARCHAR(10) | Recognized airport code at pickup, if applicable |
| dropoff_airport_code | VARCHAR(10) | Recognized airport code at dropoff, if applicable |
| Column | Type | Description |
|---|---|---|
| airport_codePK | VARCHAR(10) | Recognized airport code |
| airport_name | VARCHAR(120) | Airport name |