1. join + filter - Which airplanes fly LGA to XNA (1 POINT)
## # A tibble: 70 × 9
## tailnum year type manufacturer model engines seats speed engine
## <chr> <int> <chr> <chr> <chr> <int> <int> <int> <chr>
## 1 N0EGMQ NA <NA> <NA> <NA> NA NA NA <NA>
## 2 N501MQ NA <NA> <NA> <NA> NA NA NA <NA>
## 3 N507MQ NA <NA> <NA> <NA> NA NA NA <NA>
## 4 N510MQ NA <NA> <NA> <NA> NA NA NA <NA>
## 5 N511MQ NA <NA> <NA> <NA> NA NA NA <NA>
## 6 N512MQ NA <NA> <NA> <NA> NA NA NA <NA>
## 7 N514MQ NA <NA> <NA> <NA> NA NA NA <NA>
## 8 N518MQ NA <NA> <NA> <NA> NA NA NA <NA>
## 9 N520MQ NA <NA> <NA> <NA> NA NA NA <NA>
## 10 N521MQ NA <NA> <NA> <NA> NA NA NA <NA>
## # ℹ 60 more rows
2. join - Add the airline name to the flights table (1 POINT)
## # A tibble: 336,776 × 20
## year month day dep_time sched_dep_time dep_delay arr_time sched_arr_time
## <int> <int> <int> <int> <int> <dbl> <int> <int>
## 1 2013 1 1 517 515 2 830 819
## 2 2013 1 1 533 529 4 850 830
## 3 2013 1 1 542 540 2 923 850
## 4 2013 1 1 544 545 -1 1004 1022
## 5 2013 1 1 554 600 -6 812 837
## 6 2013 1 1 554 558 -4 740 728
## 7 2013 1 1 555 600 -5 913 854
## 8 2013 1 1 557 600 -3 709 723
## 9 2013 1 1 557 600 -3 838 846
## 10 2013 1 1 558 600 -2 753 745
## # ℹ 336,766 more rows
## # ℹ 12 more variables: arr_delay <dbl>, carrier <chr>, flight <int>,
## # tailnum <chr>, origin <chr>, dest <chr>, air_time <dbl>, distance <dbl>,
## # hour <dbl>, minute <dbl>, time_hour <dttm>, name <chr>
3. join + select + distinct() - Which airports have no commercial
flights (1 POINT)
## # A tibble: 1,355 × 2
## faa name
## <chr> <chr>
## 1 04G Lansdowne Airport
## 2 06A Moton Field Municipal Airport
## 3 06C Schaumburg Regional
## 4 06N Randall Airport
## 5 09J Jekyll Island Airport
## 6 0A9 Elizabethton Municipal Airport
## 7 0G6 Williams County Airport
## 8 0G7 Finger Lakes Regional Airport
## 9 0P2 Shoestring Aviation Airfield
## 10 0S9 Jefferson County Intl
## # ℹ 1,345 more rows