Cloud Computing Capstone Question 2.2 Solution for Task2

cccapstone_question_2.2_task2.txt

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

$ bash question2_2.sh 

 origin | dest | average
--------+------+---------
    BOS |  ONT |       0
    BOS |  SWF |       0
    BOS |  GGG |       2
    BOS |  LGA |  4.5147
    BOS |  AUS |   4.877
    BOS |  BDL |  6.3363
    BOS |  MSY |  7.3564
    BOS |  LGB |  7.5961
    BOS |  DCA |  7.9648
    BOS |  MKE |  8.0262
    CMH |  AUS |       0
    CMH |  OMA |       0
    CMH |  SYR |       0
    CMH |  MSN |       1
    CMH |  SDF |  2.9076
    CMH |  CLE |  4.6602
    CMH |  CAK |  5.0039
    CMH |  BNA |   5.017
    CMH |  IND |  5.4469
    CMH |  DAY |  5.9182
    JFK |  ABQ |       0
    JFK |  ANC |       0
    JFK |  ISP |       0
    JFK |  MYR |       0
    JFK |  SWF |       0
    JFK |  UCA |  2.6141
    JFK |  AGS |    4.75
    JFK |  STT |  5.9171
    JFK |  BQN |  5.9589
    JFK |  BGR |   6.757
    SEA |  EUG |       0
    SEA |  PIH |       1
    SEA |  PSC |  4.3119
    SEA |  CVG |  5.0983
    SEA |  BLI |  5.7921
    SEA |  MEM |  5.9726
    SEA |  YKM |  6.6223
    SEA |  MKE |  7.0342
    SEA |  LIH |  7.0541
    SEA |  SNA |   7.158
    SRQ |  EYW |       0
    SRQ |  FLL |       2
    SRQ |  MEM |   2.296
    SRQ |  MCO |  2.9596
    SRQ |  TPA |  3.4718
    SRQ |  BNA |  3.5668
    SRQ |  RDU |  3.5718
    SRQ |  IAH |  4.5466
    SRQ |  DCA |  5.1232
    SRQ |  RSW |  5.4692

(50 rows)