An external table has been registered using this DQL statement:
REGISTER TABLE airports_table (airport_nameSTRING(256), airport_code STRING(3))
Which DQL statement will return the airport_code for John F. Kennedy Airport?

A.
SELECT airport_code FROM airports_table WHERE airport_name = ‘John F. Kennedy Airport’

B.
SELECT airport_code_table FROM airport_code name = “John F. Kennedy Airport”

C.
SELECT airport_code FROM airport_code_table. airport_name = ‘John F. Kennedy Airport’

D.
SELECT airport_code FROM dm_airports_table WHERE airport_name = ‘John F. Kennedy
Airport’

Explanation: