task Column aliases · warm-up

Rename and convert a column

For every route that departs from JFK, return route_id, destination, miles (the distance_miles column) and km (miles × 1.609344, rounded to the nearest whole number).

what to return

Columns

route_iddestinationmileskm in this order

Rows

55 rows · any order

Skill

Name output columns and calculated values. Refresher: Aliases & calculated columns →

expected result

Your query should return exactly these columns and values. Run it and compare.

data you can query

U.S. Flights dataset: the first 6 rows of each table. Under each column name: the kind of value it holds, and which table it links to. Your queries run on all rows.