Cloud Computing Capstone Question 2.2 Solution

cccapstone_question_2.2.txt

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

$ bash question2_2.sh 

 origin | dest | average
--------+------+---------
    BWI |  SAV |       0
    BWI |  MLB |  2.3842
    BWI |  IAD |  3.0871
    BWI |  DAB |  3.8378
    BWI |  SRQ |  4.2689
    BWI |  CHO |  4.8261
    BWI |  MDT |  4.9014
    BWI |  UCA |  4.9399
    BWI |  OAJ |    5.32
    BWI |  GSP |  5.4311
    CMI |  ABI |       0
    CMI |  PIT |  2.1701
    CMI |  DAY |  3.6273
    CMI |  STL |  4.0183
    CMI |  PIA |  4.6324
    CMI |  CVG |  6.3794
    CMI |  DFW |  9.5562
    CMI |  ATL |  9.6927
    CMI |  ORD | 11.9432
    IAH |  MLI |       0
    IAH |  MSN |       0
    IAH |  HOU |  2.3019
    IAH |  AGS |  2.8315
    IAH |  EFD |  3.9199
    IAH |  PIH |       4
    IAH |  VCT |  5.3176
    IAH |  RNO |  5.5072
    IAH |  MTJ |   5.635
    IAH |  MDW |  5.9158
    LAX |  DRO |       0
    LAX |  IDA |       0
    LAX |  LAX |       0
    LAX |  MAF |       0
    LAX |  PIH |       0
    LAX |  RSW |       0
    LAX |  SDF |       0
    LAX |  BZN |       1
    LAX |  VIS |  2.4805
    LAX |  PMD |       3
    MIA |  SHV |       0
    MIA |  BUF |       1
    MIA |  SAN |  2.5137
    MIA |  HOU |  3.6411
    MIA |  SLC |  4.0702
    MIA |  ISP |  4.4566
    MIA |  PSE |  4.9469
    MIA |  MCI |  5.3605
    MIA |  TLH |  5.4429
    MIA |  GNV |   6.008
    SFO |  FAR |       0
    SFO |  PIH |       0
    SFO |  SDF |       0
    SFO |  MSO |  0.5833
    SFO |  LGA |  1.2121
    SFO |  OAK |  2.5486
    SFO |  PIE |  2.7283
    SFO |  BNA |  3.0649
    SFO |  SCK |       4
    SFO |  MEM |  5.4396

(59 rows)