Cloud Computing Capstone Question 2.1 Solution

cccapstone_question_2.1.txt

USE mykeyspace;
SELECT origin, carrier, average FROM task1_part2_group2_1 WHERE origin IN ('CMI', 'BWI', 'MIA', 'LAX', 'IAH', 'SFO');

$ bash question2_1.sh 

 origin | carrier | average
--------+---------+---------
    BWI |      F9 |  4.9161
    BWI |  PA (1) |  5.9429
    BWI |      CO |  7.1413
    BWI |      AA |  7.6571
    BWI |      YV |   7.676
    BWI |      NW |  8.3094
    BWI |      US |  8.5142
    BWI |      DL |  8.8151
    BWI |      TW |  9.0849
    BWI |      EA |   9.172
    CMI |      US |  2.8827
    CMI |      TW |  4.1582
    CMI |      PI |  4.5229
    CMI |      OH |  5.3643
    CMI |      DH |  9.6494
    CMI |      EV |  9.6927
    CMI |      MQ | 11.7545
    IAH |      PI |  4.6433
    IAH |  PA (1) |  5.7343
    IAH |      NW |  6.1598
    IAH |      WN |  6.2322
    IAH |      US |  7.0557
    IAH |      AA |  7.2697
    IAH |      TW |  7.4534
    IAH |      OO |  7.9431
    IAH |      HP |  8.0406
    IAH |      DL |  8.2771
    LAX |      PS |  4.9739
    LAX |      MQ |  5.0697
    LAX |      OO |  6.0953
    LAX |  ML (1) |  7.1013
    LAX |      NW |  7.2525
    LAX |      TZ |  7.4569
    LAX |      US |  7.8037
    LAX |      FL |  8.0823
    LAX |      F9 |  8.3621
    LAX |      AA |  8.4199
    MIA |      9E |     0.5
    MIA |  PA (1) |  4.8435
    MIA |      EV |  5.6696
    MIA |      XE |  6.1034
    MIA |      TZ |   6.823
    MIA |      NW |  6.9902
    MIA |      US |  7.4273
    MIA |  ML (1) |   7.632
    MIA |      UA |  8.2735
    MIA |      PI |  9.0639
    SFO |  PA (1) |  6.1396
    SFO |      PS |  6.4386
    SFO |      TZ |  7.6788
    SFO |      DL |  7.7533
    SFO |      NW |  7.9458
    SFO |      MQ |  8.1143
    SFO |      US |  8.5769
    SFO |      TW |  8.6777
    SFO |      CO |   8.876
    SFO |      F9 |  8.9112

(57 rows)