Searching and Sorting Example 1

Lab 08
======  Explore EPA Data on 2015 Vehicles ======
1:Search  2:Sort  3:Quit
Enter choice: 1
a:Company  b:Type
Enter choice: b
Enter type of car: minivan

   Company            Line            Type    MPG Annual Cost
   -------            ----            ----    --- -----------
  Chrysler  Town & Country     minivan 2WD     20        2600
  Chrysler  Town & Country     minivan 2WD     20        2600
     Dodge   Grand Caravan     minivan 2WD     20        2600
     Dodge   Grand Caravan     minivan 2WD     20        2600
     Honda     ODYSSEY 2WD     minivan 2WD     22        2400
KIA MOTORS          Sedona     minivan 2WD     20        2600
KIA MOTORS       Sedona SX     minivan 2WD     21        2500
KIA MOTORS      Sedona SXL     minivan 2WD     19        2750
     MAZDA         MAZDA 5     minivan 2WD     24        2200
    NISSAN           QUEST     minivan 2WD     22        2400
       RAM   C/V Tradesman     minivan 2WD     21        2500
       RAM   C/V Tradesman     minivan 2WD     21        2500
    TOYOTA          SIENNA     minivan 2WD     21        2500
    TOYOTA      SIENNA AWD     minivan 4WD     19        2750
14 results
Average MPG is 20.71

======  Explore EPA Data on 2015 Vehicles ======
1:Search  2:Sort  3:Quit
Enter choice: 1
a:Company  b:Type
Enter choice: a
Enter car company: aston martin

   Company            Line            Type    MPG Annual Cost
   -------            ----            ----    --- -----------
Aston Mart   V12 Vantage S     Two Seaters     14        4050
Aston Mart      V8 Vantage     Two Seaters     16        3550
Aston Mart      V8 Vantage     Two Seaters     15        3800
Aston Mart    V8 Vantage S     Two Seaters     16        3550
Aston Mart    V8 Vantage S     Two Seaters     15        3800
Aston Mart      Vantage GT     Two Seaters     16        3550
Aston Mart      Vantage GT     Two Seaters     15        3800
Aston Mart             DB9 Minicompact Car     15        3800
Aston Mart        Vanquish Minicompact Car     16        3550
Aston Mart        Rapide S Subcompact Cars     17        3350
10 results
Average MPG is 15.50

======  Explore EPA Data on 2015 Vehicles ======
1:Search  2:Sort  3:Quit
Enter choice: 2
a:Best MPG  b:Worst MPG  c:Lowest Cost  d:Highest Cost
Enter choice: a

   Company            Line            Type    MPG Annual Cost
   -------            ----            ----    --- -----------
    TOYOTA           PRIUS    Midsize Cars     50        1050
    TOYOTA         PRIUS c    Compact Cars     50        1050
     Honda          ACCORD    Midsize Cars     47        1100
Volkswagen    Jetta Hybrid    Compact Cars     45        1250
     Honda    CIVIC HYBRID    Compact Cars     45        1150
    TOYOTA         PRIUS v Midsize Station     42        1250
      Ford FUSION HYBRID F    Midsize Cars     42        1250
     LEXUS         CT 200h    Compact Cars     42        1250
    TOYOTA CAMRY HYBRID LE    Midsize Cars     41        1300
      Ford C-MAX Hybrid FW      Large Cars     40        1300
    TOYOTA CAMRY HYBRID XL    Midsize Cars     40        1300
    TOYOTA   AVALON HYBRID    Midsize Cars     40        1300
   Lincoln  MKZ HYBRID FWD    Midsize Cars     40        1300
     LEXUS         ES 300h    Midsize Cars     40        1300
Mitsubishi          MIRAGE    Compact Cars     40        1300
KIA MOTORS   Optima HYBRID    Midsize Cars     38        1400
HYUNDAI MO   Sonata HYBRID    Midsize Cars     38        1400
KIA MOTORS Optima HYBRID E    Midsize Cars     37        1400
HYUNDAI MO Sonata HYBRID L    Midsize Cars     37        1400
Mitsubishi          MIRAGE    Compact Cars     37        1400
20 results
Average MPG is 41.55

======  Explore EPA Data on 2015 Vehicles ======
1:Search  2:Sort  3:Quit
Enter choice: 1
a:Company  b:Type
Enter choice: a
Enter car company: xyz

No results found

======  Explore EPA Data on 2015 Vehicles ======
1:Search  2:Sort  3:Quit
Enter choice: 2
a:Best MPG  b:Worst MPG  c:Lowest Cost  d:Highest Cost
Enter choice: d

   Company            Line            Type    MPG Annual Cost
   -------            ----            ----    --- -----------
   Bugatti          Veyron     Two Seaters     10        5700
Lamborghin Aventador Roads     Two Seaters     12        4750
Mercedes-B        G 63 AMG Standard SUV 4W     13        4400
Mercedes-B           G 550 Standard SUV 4W     13        4400
       GMC G3500 SAVANA 2W  Vans Passenger     12        4400
       GMC G3500 SAVANA 2W  Vans Passenger     12        4400
 Chevrolet G3500 EXPRESS 2  Vans Passenger     12        4400
 Chevrolet G3500 EXPRESS 2  Vans Passenger     12        4400
       GMC G2500 SAVANA CO      Vans Cargo     12        4400
       GMC G2500 SAVANA CO      Vans Cargo     12        4400
 Chevrolet G2500 EXPRESS C      Vans Cargo     12        4400
   Ferrari              FF    Midsize Cars     13        4400
   Ferrari              FF    Midsize Cars     13        4400
   Bentley        Mulsanne    Midsize Cars     13        4400
Lamborghin Veneno Roadster     Two Seaters     13        4400
Lamborghin Aventador Coupe     Two Seaters     13        4400
   Ferrari             F12     Two Seaters     13        4400
   Ferrari             F12     Two Seaters     13        4400
Mercedes-B       GL 63 AMG Standard SUV 4W     14        4050
     LEXUS          LX 570 Standard SUV 4W     14        4050
20 results
Average MPG is 12.55

======  Explore EPA Data on 2015 Vehicles ======
1:Search  2:Sort  3:Quit
Enter choice: 3