Cloud Computing Capstone Question 2.3 Solution

cccapstone_question_2.3.txt

USE mykeyspace;
SELECT origin, dest, carrier, average FROM task1_part2_group2_3 WHERE origin = 'CMI' AND dest = 'ORD';
SELECT origin, dest, carrier, average FROM task1_part2_group2_3 WHERE origin = 'IND' AND dest = 'CMH';
SELECT origin, dest, carrier, average FROM task1_part2_group2_3 WHERE origin = 'DFW' AND dest = 'IAH';
SELECT origin, dest, carrier, average FROM task1_part2_group2_3 WHERE origin = 'LAX' AND dest = 'SFO';
SELECT origin, dest, carrier, average FROM task1_part2_group2_3 WHERE origin = 'JFK' AND dest = 'LAX';
SELECT origin, dest, carrier, average FROM task1_part2_group2_3 WHERE origin = 'ATL' AND dest = 'PHX';

$ bash question2_3.sh 

 origin | dest | carrier | average
--------+------+---------+---------
    CMI |  ORD |      MQ | 15.7392

(1 rows)

 origin | dest | carrier | average
--------+------+---------+---------
    IND |  CMH |      CO |  4.3942
    IND |  CMH |      NW |  7.6015
    IND |  CMH |      US |  7.8386
    IND |  CMH |      HP |  7.9906
    IND |  CMH |      AA |    8.25
    IND |  CMH |      DL | 12.6298
    IND |  CMH |      EA | 13.0654

(7 rows)

 origin | dest | carrier | average
--------+------+---------+---------
    DFW |  IAH |      UA |  8.8994
    DFW |  IAH |    PA 1 |  9.3333
    DFW |  IAH |      OO |  9.7365
    DFW |  IAH |      CO | 10.0006
    DFW |  IAH |      DL | 10.2044
    DFW |  IAH |      EV |  10.692
    DFW |  IAH |      AA | 12.1479
    DFW |  IAH |      XE | 12.8929
    DFW |  IAH |      MQ | 12.9759

(9 rows)

 origin | dest | carrier | average
--------+------+---------+---------
    LAX |  SFO |      PS |  5.8304
    LAX |  SFO |      TZ |  6.2381
    LAX |  SFO |      F9 |  6.9653
    LAX |  SFO |      US |  10.822
    LAX |  SFO |      MQ | 10.9335
    LAX |  SFO |      AA | 12.4655
    LAX |  SFO |      NW | 12.7903
    LAX |  SFO |      EV | 13.3987
    LAX |  SFO |      DL | 13.4839
    LAX |  SFO |      CO | 14.0017

(10 rows)

 origin | dest | carrier | average
--------+------+---------+---------
    JFK |  LAX |      UA | 11.4694
    JFK |  LAX |      HP | 14.8651
    JFK |  LAX |      AA | 15.0448
    JFK |  LAX |      DL | 16.6312
    JFK |  LAX |    PA 1 | 17.0937
    JFK |  LAX |      TW | 18.2878

(6 rows)

 origin | dest | carrier | average
--------+------+---------+---------
    ATL |  PHX |      FL |   12.61
    ATL |  PHX |      US | 12.6874
    ATL |  PHX |      HP | 13.3671
    ATL |  PHX |      DL | 13.8673
    ATL |  PHX |      EA | 14.0087

(5 rows)