Cloud Computing Capstone Question 2.1 Solution for Task2

cccapstone_question_2.1_task2.txt

USE mykeyspace;
SELECT origin, carrier, average FROM task1_part2_group2_1 WHERE origin IN ('SRQ', 'CMH', 'JFK', 'SEA', 'BOS');

$ bash question2_1.sh 

 origin | carrier | average
--------+---------+---------
    BOS |  PA (1) |  4.7603
    BOS |  ML (1) |  5.7604
    BOS |      TZ |  7.4525
    BOS |      DL |  8.4223
    BOS |      EV |  8.5383
    BOS |      EA |  9.0172
    BOS |      NW |  9.2727
    BOS |      US |    10.2
    BOS |      AA | 10.2836
    BOS |      TW | 11.1091
    CMH |  ML (1) |  4.3703
    CMH |      AA |  5.3039
    CMH |      PI |  5.7964
    CMH |      EA |  5.9524
    CMH |      NW |   6.185
    CMH |      DL |  6.2649
    CMH |      TW |  6.9556
    CMH |      US |  7.2964
    CMH |      DH |  7.7534
    CMH |      WN |  8.5369
    JFK |      UA |  7.6551
    JFK |      CO | 10.8261
    JFK |      AA | 11.2769
    JFK |  PA (1) | 12.0543
    JFK |      XE | 12.0775
    JFK |      DH | 12.1462
    JFK |      DL | 13.2652
    JFK |      B6 |  13.382
    JFK |      TW | 13.6339
    JFK |      US | 14.0109
    SEA |      PS |  5.0069
    SEA |      OO |  5.1094
    SEA |      DL |  7.5305
    SEA |      YV |  7.6989
    SEA |      US |  7.8441
    SEA |      NW |  8.1889
    SEA |      AA |   8.301
    SEA |      WN |  8.7386
    SEA |      CO |  8.9674
    SEA |      EV |  9.2519
    SRQ |      AA |  4.9032
    SRQ |      UA |  5.1568
    SRQ |      US |  5.8389
    SRQ |      TZ |  5.9312
    SRQ |      TW |  6.2078
    SRQ |      DL |  6.2812
    SRQ |      XE |  6.5688
    SRQ |      EA |  7.0679
    SRQ |      YV |  7.1801
    SRQ |      NW |  7.3034

(50 rows)