Sample output for CS451/551 Assignment 1







1.



+---------+---------+----------------------+
| fname   | lname   | company              |
+---------+---------+----------------------+
| Philip  | Currie  | Phil's Sports        |
| Raymond | Vector  | Los Altos Sports     |
| Donald  | Quinn   | Quinn's Sports       |
| Alfred  | Grant   | Gold Medal Sports    |
| Dick    | Baxter  | Blue Ribbon Sports   |
| Jason   | Wallack | City Sports          |
| Marvin  | Hanlon  | Bay Sports           |
| James   | Henry   | Total Fitness Sports |
+---------+---------+----------------------+
8 rows in set (0.00 sec)







2.


+---------------+---------------+-------+-----------------+------------+
| customer_name | city          | state | description     | order_date |
+---------------+---------------+-------+-----------------+------------+
| George Watson | Mountain View | CA    | baseball gloves | 1998-05-22 |
| George Watson | Mountain View | CA    | baseball bat    | 1998-05-22 |
| Arnold Sipes  | Redwood City  | CA    | baseball bat    | 1998-05-31 |
| George Watson | Mountain View | CA    | football        | 1998-06-25 |
+---------------+---------------+-------+-----------------+------------+
4 rows in set (0.00 sec)






3.



+----------------+----------+-----------+

| sname          | fname    | lname     |

+----------------+----------+-----------+

| Alabama        | NULL     | NULL      |

| Alaska         | NULL     | NULL      |

| Arizona        | Fred     | Jewell    |

| Arizona        | Frank    | Lessor    |

| Arkansas       | NULL     | NULL      |

| California     | Anthony  | Higgins   |

| California     | Alfred   | Grant     |

| California     | Roy      | Jaeger    |

| California     | Raymond  | Vector    |

| California     | Jean     | Parmelee  |

| California     | Frances  | Keyes     |

| California     | George   | Watson    |

| California     | Ludwig   | Pauli     |

...

+----------------+----------+-----------+

71 rows in set (0.00 sec)









4.



+----------+---------+
| fname    | lname   |
+----------+---------+
| Joyce    | English |
| Franklin | Wong    |
+----------+---------+
2 rows in set (0.00 sec)







5.



+----------------+----------------+



| dname          | dependent_name |



+----------------+----------------+



| Research       | Alice          |



| Research       | Elizabeth      |



| Research       | Michael        |



| Research       | Alice          |



| Research       | Joy            |



| Research       | Theodore       |



| Headquarters   | NULL           |



| Administration | Abner          |



+----------------+----------------+



8 rows in set










6.



+------------------+---------------+


| supervisor       | supervisee    |


+------------------+---------------+


| Jennifer Wallace | Ahmad Jabbar  |


| Jennifer Wallace | Alicia Zelaya |


+------------------+---------------+


2 rows in set (0.00 sec)










7.



+-----------------------+-----------------------------+---------------------+



| customername          | title                       | rental_date         |



+-----------------------+-----------------------------+---------------------+



| JOEL FRANCISCO        | ACADEMY DINOSAUR            | 2005-07-08 19:03:15 |



| GERALDINE PERKINS     | ACADEMY DINOSAUR            | 2005-07-07 10:41:31 |



| VIRGIL WOFFORD        | ACADEMY DINOSAUR            | 2005-07-30 22:02:34 |



|......                 |                             |                     |



6709 rows in set







8.



Two answers are acceptable:


+------------+--------------+------------------------------------------+--------+
| first_name | last_name    | email                                    | amount |
+------------+--------------+------------------------------------------+--------+
| RAFAEL     | ABNEY        | RAFAEL.ABNEY@sakilacustomer.org          |   6.99 |
| NATHANIEL  | ADAM         | NATHANIEL.ADAM@sakilacustomer.org        |   6.99 |
| NATHANIEL  | ADAM         | NATHANIEL.ADAM@sakilacustomer.org        |   9.99 |
| NATHANIEL  | ADAM         | NATHANIEL.ADAM@sakilacustomer.org        |   9.99 |
| GORDON     | ALLARD       | GORDON.ALLARD@sakilacustomer.org         |   8.99 |
| CHARLENE   | ALVAREZ      | CHARLENE.ALVAREZ@sakilacustomer.org      |   8.99 |
| CHARLENE   | ALVAREZ      | CHARLENE.ALVAREZ@sakilacustomer.org      |   9.99 |
| LISA       | ANDERSON     | LISA.ANDERSON@sakilacustomer.org         |   9.99 |
| JORDAN     | ARCHULETA    | JORDAN.ARCHULETA@sakilacustomer.org      |   9.99 |
| BEATRICE   | ARNOLD       | BEATRICE.ARNOLD@sakilacustomer.org       |   8.99 |
| TYRONE     | ASHER        | TYRONE.ASHER@sakilacustomer.org          |   6.99 |
| TRACEY     | BARRETT      | TRACEY.BARRETT@sakilacustomer.org        |   7.99 |
| EDWARD     | BAUGH        | EDWARD.BAUGH@sakilacustomer.org          |   8.99 |
| MIGUEL     | BETANCOURT   | MIGUEL.BETANCOURT@sakilacustomer.org     |   9.99 |
| AGNES      | BISHOP       | AGNES.BISHOP@sakilacustomer.org          |   6.99 |
| AGNES      | BISHOP       | AGNES.BISHOP@sakilacustomer.org          |   8.99 |
| LEON       | BOSTIC       | LEON.BOSTIC@sakilacustomer.org           |   8.99 |
| BOBBY      | BOUDREAU     | BOBBY.BOUDREAU@sakilacustomer.org        |   8.99 |
| DERRICK    | BOURQUE      | DERRICK.BOURQUE@sakilacustomer.org       |   6.99 |
| EMMA       | BOYD         | EMMA.BOYD@sakilacustomer.org             |   9.99 |
| ANA        | BRADLEY      | ANA.BRADLEY@sakilacustomer.org           |   8.99 |
| GUY        | BROWNLEE     | GUY.BROWNLEE@sakilacustomer.org          |   6.99 |
| SIDNEY     | BURLESON     | SIDNEY.BURLESON@sakilacustomer.org       |   6.99 |
| SIDNEY     | BURLESON     | SIDNEY.BURLESON@sakilacustomer.org       |   7.99 |
| KAY        | CALDWELL     | KAY.CALDWELL@sakilacustomer.org          |   6.99 |
| KAY        | CALDWELL     | KAY.CALDWELL@sakilacustomer.org          |   7.99 |
| CHAD       | CARBONE      | CHAD.CARBONE@sakilacustomer.org          |   6.99 |
| TERRY      | CARLSON      | TERRY.CARLSON@sakilacustomer.org         |   6.99 |
| JUNE       | CARROLL      | JUNE.CARROLL@sakilacustomer.org          |   7.99 |
| AMANDA     | CARTER       | AMANDA.CARTER@sakilacustomer.org         |   6.99 |
| ALFRED     | CASILLAS     | ALFRED.CASILLAS@sakilacustomer.org       |   8.99 |
| ALFRED     | CASILLAS     | ALFRED.CASILLAS@sakilacustomer.org       |   9.99 |
| GERTRUDE   | CASTILLO     | GERTRUDE.CASTILLO@sakilacustomer.org     |   6.99 |
| GERTRUDE   | CASTILLO     | GERTRUDE.CASTILLO@sakilacustomer.org     |   6.99 |
| KRISTINA   | CHAMBERS     | KRISTINA.CHAMBERS@sakilacustomer.org     |   6.99 |
| VERNON     | CHAPA        | VERNON.CHAPA@sakilacustomer.org          |   6.99 |
| VERNON     | CHAPA        | VERNON.CHAPA@sakilacustomer.org          |   8.99 |
| KRISTEN    | CHAVEZ       | KRISTEN.CHAVEZ@sakilacustomer.org        |   7.99 |
| NELSON     | CHRISTENSON  | NELSON.CHRISTENSON@sakilacustomer.org    |   7.99 |
| AUSTIN     | CINTRON      | AUSTIN.CINTRON@sakilacustomer.org        |   9.99 |
| ADRIAN     | CLARY        | ADRIAN.CLARY@sakilacustomer.org          |   7.99 |
| BERNARD    | COLBY        | BERNARD.COLBY@sakilacustomer.org         |   7.99 |
| KATHRYN    | COLEMAN      | KATHRYN.COLEMAN@sakilacustomer.org       |   8.99 |
| DIANE      | COLLINS      | DIANE.COLLINS@sakilacustomer.org         |   6.99 |
| GLORIA     | COOK         | GLORIA.COOK@sakilacustomer.org           |   8.99 |
| ALLAN      | CORNISH      | ALLAN.CORNISH@sakilacustomer.org         |   6.99 |
| BRETT      | CORNWELL     | BRETT.CORNWELL@sakilacustomer.org        |   9.99 |
| BOBBIE     | CRAIG        | BOBBIE.CRAIG@sakilacustomer.org          |   6.99 |
| BOBBIE     | CRAIG        | BOBBIE.CRAIG@sakilacustomer.org          |   9.99 |
| LEAH       | CURTIS       | LEAH.CURTIS@sakilacustomer.org           |   7.99 |
| JENNIFER   | DAVIS        | JENNIFER.DAVIS@sakilacustomer.org        |   7.99 |
| RON        | DELUCA       | RON.DELUCA@sakilacustomer.org            |   7.99 |
| AMBER      | DIXON        | AMBER.DIXON@sakilacustomer.org           |   7.99 |
| SEAN       | DOUGLASS     | SEAN.DOUGLASS@sakilacustomer.org         |   6.99 |
| SEAN       | DOUGLASS     | SEAN.DOUGLASS@sakilacustomer.org         |   9.99 |
| ERIN       | DUNN         | ERIN.DUNN@sakilacustomer.org             |   7.99 |
| JEFF       | EAST         | JEFF.EAST@sakilacustomer.org             |   7.99 |
| GRACE      | ELLIS        | GRACE.ELLIS@sakilacustomer.org           |   6.99 |
| KURT       | EMMONS       | KURT.EMMONS@sakilacustomer.org           |   8.99 |
| JOHN       | FARNSWORTH   | JOHN.FARNSWORTH@sakilacustomer.org       |   9.99 |
| ALEXANDER  | FENNELL      | ALEXANDER.FENNELL@sakilacustomer.org     |   6.99 |
| MYRTLE     | FLEMING      | MYRTLE.FLEMING@sakilacustomer.org        |   6.99 |
| MYRTLE     | FLEMING      | MYRTLE.FLEMING@sakilacustomer.org        |   9.99 |
| JULIA      | FLORES       | JULIA.FLORES@sakilacustomer.org          |   7.99 |
| JULIA      | FLORES       | JULIA.FLORES@sakilacustomer.org          |   7.99 |
| HOWARD     | FORTNER      | HOWARD.FORTNER@sakilacustomer.org        |  10.99 |
| BETH       | FRANKLIN     | BETH.FRANKLIN@sakilacustomer.org         |   8.99 |
| GERALD     | FULTZ        | GERALD.FULTZ@sakilacustomer.org          |   6.99 |
| FELIX      | GAFFNEY      | FELIX.GAFFNEY@sakilacustomer.org         |   6.99 |
| JAMES      | GANNON       | JAMES.GANNON@sakilacustomer.org          |   6.99 |
| JAMES      | GANNON       | JAMES.GANNON@sakilacustomer.org          |   8.99 |
| JOANN      | GARDNER      | JOANN.GARDNER@sakilacustomer.org         |   6.99 |
| JOANN      | GARDNER      | JOANN.GARDNER@sakilacustomer.org         |   8.99 |
| RUBEN      | GEARY        | RUBEN.GEARY@sakilacustomer.org           |   7.99 |
| TANYA      | GILBERT      | TANYA.GILBERT@sakilacustomer.org         |   6.99 |
| TANYA      | GILBERT      | TANYA.GILBERT@sakilacustomer.org         |   8.99 |
| BRANDY     | GRAVES       | BRANDY.GRAVES@sakilacustomer.org         |   8.99 |
| JUDY       | GRAY         | JUDY.GRAY@sakilacustomer.org             |   6.99 |
| VIRGINIA   | GREEN        | VIRGINIA.GREEN@sakilacustomer.org        |   6.99 |
| VIRGINIA   | GREEN        | VIRGINIA.GREEN@sakilacustomer.org        |   6.99 |
| HARVEY     | GUAJARDO     | HARVEY.GUAJARDO@sakilacustomer.org       |   6.99 |
| JESSICA    | HALL         | JESSICA.HALL@sakilacustomer.org          |   6.99 |
| GLADYS     | HAMILTON     | GLADYS.HAMILTON@sakilacustomer.org       |   8.99 |
| DELORES    | HANSEN       | DELORES.HANSEN@sakilacustomer.org        |   8.99 |
| GABRIEL    | HARDER       | GABRIEL.HARDER@sakilacustomer.org        |   6.99 |
| BRYAN      | HARDISON     | BRYAN.HARDISON@sakilacustomer.org        |   6.99 |
| WENDY      | HARRISON     | WENDY.HARRISON@sakilacustomer.org        |   6.99 |
| ARLENE     | HARVEY       | ARLENE.HARVEY@sakilacustomer.org         |   7.99 |
| ARNOLD     | HAVENS       | ARNOLD.HAVENS@sakilacustomer.org         |   6.99 |
| ALBERTO    | HENNING      | ALBERTO.HENNING@sakilacustomer.org       |   6.99 |
| ANGELA     | HERNANDEZ    | ANGELA.HERNANDEZ@sakilacustomer.org      |   6.99 |
| ANGELA     | HERNANDEZ    | ANGELA.HERNANDEZ@sakilacustomer.org      |   7.99 |
| NORA       | HERRERA      | NORA.HERRERA@sakilacustomer.org          |   8.99 |
| TRACY      | HERRMANN     | TRACY.HERRMANN@sakilacustomer.org        |   8.99 |
| MABEL      | HOLLAND      | MABEL.HOLLAND@sakilacustomer.org         |   7.99 |
| FREDERICK  | ISBELL       | FREDERICK.ISBELL@sakilacustomer.org      |   6.99 |
| KAREN      | JACKSON      | KAREN.JACKSON@sakilacustomer.org         |  11.99 |
| LENA       | JENSEN       | LENA.JENSEN@sakilacustomer.org           |   7.99 |
| KRISTIN    | JOHNSTON     | KRISTIN.JOHNSTON@sakilacustomer.org      |   9.99 |
| TIFFANY    | JORDAN       | TIFFANY.JORDAN@sakilacustomer.org        |   7.99 |
| TIFFANY    | JORDAN       | TIFFANY.JORDAN@sakilacustomer.org        |   7.99 |
| JERRY      | JORDON       | JERRY.JORDON@sakilacustomer.org          |   6.99 |
| JERRY      | JORDON       | JERRY.JORDON@sakilacustomer.org          |   6.99 |
| REGINALD   | KINDER       | REGINALD.KINDER@sakilacustomer.org       |   6.99 |
| LESTER     | KRAUS        | LESTER.KRAUS@sakilacustomer.org          |   9.99 |
| MISTY      | LAMBERT      | MISTY.LAMBERT@sakilacustomer.org         |  10.99 |
| DARYL      | LARUE        | DARYL.LARUE@sakilacustomer.org           |   9.99 |
| DWIGHT     | LOMBARDI     | DWIGHT.LOMBARDI@sakilacustomer.org       |   7.99 |
| AMY        | LOPEZ        | AMY.LOPEZ@sakilacustomer.org             |   6.99 |
| AMY        | LOPEZ        | AMY.LOPEZ@sakilacustomer.org             |   8.99 |
| RICK       | MATTOX       | RICK.MATTOX@sakilacustomer.org           |   8.99 |
| GWENDOLYN  | MAY          | GWENDOLYN.MAY@sakilacustomer.org         |   8.99 |
| VERA       | MCCOY        | VERA.MCCOY@sakilacustomer.org            |   6.99 |
| SAM        | MCDUFFIE     | SAM.MCDUFFIE@sakilacustomer.org          |   6.99 |
| MIRIAM     | MCKINNEY     | MIRIAM.MCKINNEY@sakilacustomer.org       |   9.99 |
| NATALIE    | MEYER        | NATALIE.MEYER@sakilacustomer.org         |   6.99 |
| NATALIE    | MEYER        | NATALIE.MEYER@sakilacustomer.org         |   6.99 |
| MARIA      | MILLER       | MARIA.MILLER@sakilacustomer.org          |   8.99 |
| TOM        | MILNER       | TOM.MILNER@sakilacustomer.org            |   6.99 |
| STEPHANIE  | MITCHELL     | STEPHANIE.MITCHELL@sakilacustomer.org    |   7.99 |
| STACEY     | MONTGOMERY   | STACEY.MONTGOMERY@sakilacustomer.org     |   8.99 |
| ANITA      | MORALES      | ANITA.MORALES@sakilacustomer.org         |  10.99 |
| STELLA     | MORENO       | STELLA.MORENO@sakilacustomer.org         |   7.99 |
| JASON      | MORRISSEY    | JASON.MORRISSEY@sakilacustomer.org       |   7.99 |
| THELMA     | MURRAY       | THELMA.MURRAY@sakilacustomer.org         |   7.99 |
| TAMARA     | NGUYEN       | TAMARA.NGUYEN@sakilacustomer.org         |   7.99 |
| ELMER      | NOE          | ELMER.NOE@sakilacustomer.org             |   6.99 |
| ISAAC      | OGLESBY      | ISAAC.OGLESBY@sakilacustomer.org         |   8.99 |
| ANNETTE    | OLSON        | ANNETTE.OLSON@sakilacustomer.org         |   6.99 |
| WANDA      | PATTERSON    | WANDA.PATTERSON@sakilacustomer.org       |   7.99 |
| GERALDINE  | PERKINS      | GERALDINE.PERKINS@sakilacustomer.org     |   7.99 |
| IRENE      | PRICE        | IRENE.PRICE@sakilacustomer.org           |   6.99 |
| STEPHEN    | QUALLS       | STEPHEN.QUALLS@sakilacustomer.org        |   6.99 |
| TROY       | QUIGLEY      | TROY.QUIGLEY@sakilacustomer.org          |   7.99 |
| VINCENT    | RALSTON      | VINCENT.RALSTON@sakilacustomer.org       |   9.99 |
| VINCENT    | RALSTON      | VINCENT.RALSTON@sakilacustomer.org       |  10.99 |
| ANDRE      | RAPP         | ANDRE.RAPP@sakilacustomer.org            |   6.99 |
| DALE       | RATCLIFF     | DALE.RATCLIFF@sakilacustomer.org         |   9.99 |
| DORIS      | REED         | DORIS.REED@sakilacustomer.org            |   6.99 |
| DORIS      | REED         | DORIS.REED@sakilacustomer.org            |   7.99 |
| NEIL       | RENNER       | NEIL.RENNER@sakilacustomer.org           |   7.99 |
| DEBBIE     | REYES        | DEBBIE.REYES@sakilacustomer.org          |   7.99 |
| ROSA       | REYNOLDS     | ROSA.REYNOLDS@sakilacustomer.org         |   8.99 |
| EDGAR      | RHOADS       | EDGAR.RHOADS@sakilacustomer.org          |   6.99 |
| JAMIE      | RICE         | JAMIE.RICE@sakilacustomer.org            |   6.99 |
| ASHLEY     | RICHARDSON   | ASHLEY.RICHARDSON@sakilacustomer.org     |   6.99 |
| KEITH      | RICO         | KEITH.RICO@sakilacustomer.org            |   6.99 |
| BRITTANY   | RILEY        | BRITTANY.RILEY@sakilacustomer.org        |   7.99 |
| ERIC       | ROBERT       | ERIC.ROBERT@sakilacustomer.org           |   7.99 |
| ERIC       | ROBERT       | ERIC.ROBERT@sakilacustomer.org           |   8.99 |
| VIOLET     | RODRIQUEZ    | VIOLET.RODRIQUEZ@sakilacustomer.org      |   7.99 |
| MINNIE     | ROMERO       | MINNIE.ROMERO@sakilacustomer.org         |   6.99 |
| TARA       | RYAN         | TARA.RYAN@sakilacustomer.org             |   6.99 |
| TARA       | RYAN         | TARA.RYAN@sakilacustomer.org             |  10.99 |
| RYAN       | SALISBURY    | RYAN.SALISBURY@sakilacustomer.org        |   8.99 |
| DEAN       | SAUER        | DEAN.SAUER@sakilacustomer.org            |   8.99 |
| LESLIE     | SEWARD       | LESLIE.SEWARD@sakilacustomer.org         |   9.99 |
| CLARA      | SHAW         | CLARA.SHAW@sakilacustomer.org            |   6.99 |
| FRANCIS    | SIKES        | FRANCIS.SIKES@sakilacustomer.org         |   7.99 |
| MICHAEL    | SILVERMAN    | MICHAEL.SILVERMAN@sakilacustomer.org     |   7.99 |
| VANESSA    | SIMS         | VANESSA.SIMS@sakilacustomer.org          |  11.99 |
| MARION     | SNYDER       | MARION.SNYDER@sakilacustomer.org         |   6.99 |
| MARION     | SNYDER       | MARION.SNYDER@sakilacustomer.org         |   6.99 |
| NINA       | SOTO         | NINA.SOTO@sakilacustomer.org             |   7.99 |
| JEFFREY    | SPEAR        | JEFFREY.SPEAR@sakilacustomer.org         |   7.99 |
| KYLE       | SPURLOCK     | KYLE.SPURLOCK@sakilacustomer.org         |   6.99 |
| KYLE       | SPURLOCK     | KYLE.SPURLOCK@sakilacustomer.org         |   8.99 |
| KIRK       | STCLAIR      | KIRK.STCLAIR@sakilacustomer.org          |   8.99 |
| ALICE      | STEWART      | ALICE.STEWART@sakilacustomer.org         |   6.99 |
| VERONICA   | STONE        | VERONICA.STONE@sakilacustomer.org        |   8.99 |
| GLEN       | TALBERT      | GLEN.TALBERT@sakilacustomer.org          |   8.99 |
| DOROTHY    | TAYLOR       | DOROTHY.TAYLOR@sakilacustomer.org        |   8.99 |
| NANCY      | THOMAS       | NANCY.THOMAS@sakilacustomer.org          |  10.99 |
| CLYDE      | TOBIAS       | CLYDE.TOBIAS@sakilacustomer.org          |   8.99 |
| PAUL       | TROUT        | PAUL.TROUT@sakilacustomer.org            |   8.99 |
| MARJORIE   | TUCKER       | MARJORIE.TUCKER@sakilacustomer.org       |   8.99 |
| CASSANDRA  | WALTERS      | CASSANDRA.WALTERS@sakilacustomer.org     |   6.99 |
| CASSANDRA  | WALTERS      | CASSANDRA.WALTERS@sakilacustomer.org     |   9.99 |
| RUBY       | WASHINGTON   | RUBY.WASHINGTON@sakilacustomer.org       |   7.99 |
| RUBY       | WASHINGTON   | RUBY.WASHINGTON@sakilacustomer.org       |   7.99 |
| YVONNE     | WATKINS      | YVONNE.WATKINS@sakilacustomer.org        |   7.99 |
| THERESA    | WATSON       | THERESA.WATSON@sakilacustomer.org        |   6.99 |
| SHEILA     | WELLS        | SHEILA.WELLS@sakilacustomer.org          |   8.99 |
| MITCHELL   | WESTMORELAND | MITCHELL.WESTMORELAND@sakilacustomer.org |   7.99 |
| FRED       | WHEAT        | FRED.WHEAT@sakilacustomer.org            |   7.99 |
| BETTY      | WHITE        | BETTY.WHITE@sakilacustomer.org           |   7.99 |
| FLORENCE   | WOODS        | FLORENCE.WOODS@sakilacustomer.org        |   6.99 |
| BRENDA     | WRIGHT       | BRENDA.WRIGHT@sakilacustomer.org         |   6.99 |
| BRENDA     | WRIGHT       | BRENDA.WRIGHT@sakilacustomer.org         |   9.99 |
+------------+--------------+------------------------------------------+--------+
189 rows in set (0.02 sec)






+------------+--------------+------------------------------------------+
| first_name | last_name    | email                                    |
+------------+--------------+------------------------------------------+
| RAFAEL     | ABNEY        | RAFAEL.ABNEY@sakilacustomer.org          |
| NATHANIEL  | ADAM         | NATHANIEL.ADAM@sakilacustomer.org        |
| GORDON     | ALLARD       | GORDON.ALLARD@sakilacustomer.org         |
| CHARLENE   | ALVAREZ      | CHARLENE.ALVAREZ@sakilacustomer.org      |
| LISA       | ANDERSON     | LISA.ANDERSON@sakilacustomer.org         |
| JORDAN     | ARCHULETA    | JORDAN.ARCHULETA@sakilacustomer.org      |
| BEATRICE   | ARNOLD       | BEATRICE.ARNOLD@sakilacustomer.org       |
| TYRONE     | ASHER        | TYRONE.ASHER@sakilacustomer.org          |
| TRACEY     | BARRETT      | TRACEY.BARRETT@sakilacustomer.org        |
| EDWARD     | BAUGH        | EDWARD.BAUGH@sakilacustomer.org          |
| MIGUEL     | BETANCOURT   | MIGUEL.BETANCOURT@sakilacustomer.org     |
| AGNES      | BISHOP       | AGNES.BISHOP@sakilacustomer.org          |
| LEON       | BOSTIC       | LEON.BOSTIC@sakilacustomer.org           |
| BOBBY      | BOUDREAU     | BOBBY.BOUDREAU@sakilacustomer.org        |
| DERRICK    | BOURQUE      | DERRICK.BOURQUE@sakilacustomer.org       |
| EMMA       | BOYD         | EMMA.BOYD@sakilacustomer.org             |
| ANA        | BRADLEY      | ANA.BRADLEY@sakilacustomer.org           |
| GUY        | BROWNLEE     | GUY.BROWNLEE@sakilacustomer.org          |
| SIDNEY     | BURLESON     | SIDNEY.BURLESON@sakilacustomer.org       |
| KAY        | CALDWELL     | KAY.CALDWELL@sakilacustomer.org          |
| CHAD       | CARBONE      | CHAD.CARBONE@sakilacustomer.org          |
| TERRY      | CARLSON      | TERRY.CARLSON@sakilacustomer.org         |
| JUNE       | CARROLL      | JUNE.CARROLL@sakilacustomer.org          |
| AMANDA     | CARTER       | AMANDA.CARTER@sakilacustomer.org         |
| ALFRED     | CASILLAS     | ALFRED.CASILLAS@sakilacustomer.org       |
| GERTRUDE   | CASTILLO     | GERTRUDE.CASTILLO@sakilacustomer.org     |
| KRISTINA   | CHAMBERS     | KRISTINA.CHAMBERS@sakilacustomer.org     |
| VERNON     | CHAPA        | VERNON.CHAPA@sakilacustomer.org          |
| KRISTEN    | CHAVEZ       | KRISTEN.CHAVEZ@sakilacustomer.org        |
| NELSON     | CHRISTENSON  | NELSON.CHRISTENSON@sakilacustomer.org    |
| AUSTIN     | CINTRON      | AUSTIN.CINTRON@sakilacustomer.org        |
| ADRIAN     | CLARY        | ADRIAN.CLARY@sakilacustomer.org          |
| BERNARD    | COLBY        | BERNARD.COLBY@sakilacustomer.org         |
| KATHRYN    | COLEMAN      | KATHRYN.COLEMAN@sakilacustomer.org       |
| DIANE      | COLLINS      | DIANE.COLLINS@sakilacustomer.org         |
| GLORIA     | COOK         | GLORIA.COOK@sakilacustomer.org           |
| ALLAN      | CORNISH      | ALLAN.CORNISH@sakilacustomer.org         |
| BRETT      | CORNWELL     | BRETT.CORNWELL@sakilacustomer.org        |
| BOBBIE     | CRAIG        | BOBBIE.CRAIG@sakilacustomer.org          |
| LEAH       | CURTIS       | LEAH.CURTIS@sakilacustomer.org           |
| JENNIFER   | DAVIS        | JENNIFER.DAVIS@sakilacustomer.org        |
| RON        | DELUCA       | RON.DELUCA@sakilacustomer.org            |
| AMBER      | DIXON        | AMBER.DIXON@sakilacustomer.org           |
| SEAN       | DOUGLASS     | SEAN.DOUGLASS@sakilacustomer.org         |
| ERIN       | DUNN         | ERIN.DUNN@sakilacustomer.org             |
| JEFF       | EAST         | JEFF.EAST@sakilacustomer.org             |
| GRACE      | ELLIS        | GRACE.ELLIS@sakilacustomer.org           |
| KURT       | EMMONS       | KURT.EMMONS@sakilacustomer.org           |
| JOHN       | FARNSWORTH   | JOHN.FARNSWORTH@sakilacustomer.org       |
| ALEXANDER  | FENNELL      | ALEXANDER.FENNELL@sakilacustomer.org     |
| MYRTLE     | FLEMING      | MYRTLE.FLEMING@sakilacustomer.org        |
| JULIA      | FLORES       | JULIA.FLORES@sakilacustomer.org          |
| HOWARD     | FORTNER      | HOWARD.FORTNER@sakilacustomer.org        |
| BETH       | FRANKLIN     | BETH.FRANKLIN@sakilacustomer.org         |
| GERALD     | FULTZ        | GERALD.FULTZ@sakilacustomer.org          |
| FELIX      | GAFFNEY      | FELIX.GAFFNEY@sakilacustomer.org         |
| JAMES      | GANNON       | JAMES.GANNON@sakilacustomer.org          |
| JOANN      | GARDNER      | JOANN.GARDNER@sakilacustomer.org         |
| RUBEN      | GEARY        | RUBEN.GEARY@sakilacustomer.org           |
| TANYA      | GILBERT      | TANYA.GILBERT@sakilacustomer.org         |
| BRANDY     | GRAVES       | BRANDY.GRAVES@sakilacustomer.org         |
| JUDY       | GRAY         | JUDY.GRAY@sakilacustomer.org             |
| VIRGINIA   | GREEN        | VIRGINIA.GREEN@sakilacustomer.org        |
| HARVEY     | GUAJARDO     | HARVEY.GUAJARDO@sakilacustomer.org       |
| JESSICA    | HALL         | JESSICA.HALL@sakilacustomer.org          |
| GLADYS     | HAMILTON     | GLADYS.HAMILTON@sakilacustomer.org       |
| DELORES    | HANSEN       | DELORES.HANSEN@sakilacustomer.org        |
| GABRIEL    | HARDER       | GABRIEL.HARDER@sakilacustomer.org        |
| BRYAN      | HARDISON     | BRYAN.HARDISON@sakilacustomer.org        |
| WENDY      | HARRISON     | WENDY.HARRISON@sakilacustomer.org        |
| ARLENE     | HARVEY       | ARLENE.HARVEY@sakilacustomer.org         |
| ARNOLD     | HAVENS       | ARNOLD.HAVENS@sakilacustomer.org         |
| ALBERTO    | HENNING      | ALBERTO.HENNING@sakilacustomer.org       |
| ANGELA     | HERNANDEZ    | ANGELA.HERNANDEZ@sakilacustomer.org      |
| NORA       | HERRERA      | NORA.HERRERA@sakilacustomer.org          |
| TRACY      | HERRMANN     | TRACY.HERRMANN@sakilacustomer.org        |
| MABEL      | HOLLAND      | MABEL.HOLLAND@sakilacustomer.org         |
| FREDERICK  | ISBELL       | FREDERICK.ISBELL@sakilacustomer.org      |
| KAREN      | JACKSON      | KAREN.JACKSON@sakilacustomer.org         |
| LENA       | JENSEN       | LENA.JENSEN@sakilacustomer.org           |
| KRISTIN    | JOHNSTON     | KRISTIN.JOHNSTON@sakilacustomer.org      |
| TIFFANY    | JORDAN       | TIFFANY.JORDAN@sakilacustomer.org        |
| JERRY      | JORDON       | JERRY.JORDON@sakilacustomer.org          |
| REGINALD   | KINDER       | REGINALD.KINDER@sakilacustomer.org       |
| LESTER     | KRAUS        | LESTER.KRAUS@sakilacustomer.org          |
| MISTY      | LAMBERT      | MISTY.LAMBERT@sakilacustomer.org         |
| DARYL      | LARUE        | DARYL.LARUE@sakilacustomer.org           |
| DWIGHT     | LOMBARDI     | DWIGHT.LOMBARDI@sakilacustomer.org       |
| AMY        | LOPEZ        | AMY.LOPEZ@sakilacustomer.org             |
| RICK       | MATTOX       | RICK.MATTOX@sakilacustomer.org           |
| GWENDOLYN  | MAY          | GWENDOLYN.MAY@sakilacustomer.org         |
| VERA       | MCCOY        | VERA.MCCOY@sakilacustomer.org            |
| SAM        | MCDUFFIE     | SAM.MCDUFFIE@sakilacustomer.org          |
| MIRIAM     | MCKINNEY     | MIRIAM.MCKINNEY@sakilacustomer.org       |
| NATALIE    | MEYER        | NATALIE.MEYER@sakilacustomer.org         |
| MARIA      | MILLER       | MARIA.MILLER@sakilacustomer.org          |
| TOM        | MILNER       | TOM.MILNER@sakilacustomer.org            |
| STEPHANIE  | MITCHELL     | STEPHANIE.MITCHELL@sakilacustomer.org    |
| STACEY     | MONTGOMERY   | STACEY.MONTGOMERY@sakilacustomer.org     |
| ANITA      | MORALES      | ANITA.MORALES@sakilacustomer.org         |
| STELLA     | MORENO       | STELLA.MORENO@sakilacustomer.org         |
| JASON      | MORRISSEY    | JASON.MORRISSEY@sakilacustomer.org       |
| THELMA     | MURRAY       | THELMA.MURRAY@sakilacustomer.org         |
| TAMARA     | NGUYEN       | TAMARA.NGUYEN@sakilacustomer.org         |
| ELMER      | NOE          | ELMER.NOE@sakilacustomer.org             |
| ISAAC      | OGLESBY      | ISAAC.OGLESBY@sakilacustomer.org         |
| ANNETTE    | OLSON        | ANNETTE.OLSON@sakilacustomer.org         |
| WANDA      | PATTERSON    | WANDA.PATTERSON@sakilacustomer.org       |
| GERALDINE  | PERKINS      | GERALDINE.PERKINS@sakilacustomer.org     |
| IRENE      | PRICE        | IRENE.PRICE@sakilacustomer.org           |
| STEPHEN    | QUALLS       | STEPHEN.QUALLS@sakilacustomer.org        |
| TROY       | QUIGLEY      | TROY.QUIGLEY@sakilacustomer.org          |
| VINCENT    | RALSTON      | VINCENT.RALSTON@sakilacustomer.org       |
| ANDRE      | RAPP         | ANDRE.RAPP@sakilacustomer.org            |
| DALE       | RATCLIFF     | DALE.RATCLIFF@sakilacustomer.org         |
| DORIS      | REED         | DORIS.REED@sakilacustomer.org            |
| NEIL       | RENNER       | NEIL.RENNER@sakilacustomer.org           |
| DEBBIE     | REYES        | DEBBIE.REYES@sakilacustomer.org          |
| ROSA       | REYNOLDS     | ROSA.REYNOLDS@sakilacustomer.org         |
| EDGAR      | RHOADS       | EDGAR.RHOADS@sakilacustomer.org          |
| JAMIE      | RICE         | JAMIE.RICE@sakilacustomer.org            |
| ASHLEY     | RICHARDSON   | ASHLEY.RICHARDSON@sakilacustomer.org     |
| KEITH      | RICO         | KEITH.RICO@sakilacustomer.org            |
| BRITTANY   | RILEY        | BRITTANY.RILEY@sakilacustomer.org        |
| ERIC       | ROBERT       | ERIC.ROBERT@sakilacustomer.org           |
| VIOLET     | RODRIQUEZ    | VIOLET.RODRIQUEZ@sakilacustomer.org      |
| MINNIE     | ROMERO       | MINNIE.ROMERO@sakilacustomer.org         |
| TARA       | RYAN         | TARA.RYAN@sakilacustomer.org             |
| RYAN       | SALISBURY    | RYAN.SALISBURY@sakilacustomer.org        |
| DEAN       | SAUER        | DEAN.SAUER@sakilacustomer.org            |
| LESLIE     | SEWARD       | LESLIE.SEWARD@sakilacustomer.org         |
| CLARA      | SHAW         | CLARA.SHAW@sakilacustomer.org            |
| FRANCIS    | SIKES        | FRANCIS.SIKES@sakilacustomer.org         |
| MICHAEL    | SILVERMAN    | MICHAEL.SILVERMAN@sakilacustomer.org     |
| VANESSA    | SIMS         | VANESSA.SIMS@sakilacustomer.org          |
| MARION     | SNYDER       | MARION.SNYDER@sakilacustomer.org         |
| NINA       | SOTO         | NINA.SOTO@sakilacustomer.org             |
| JEFFREY    | SPEAR        | JEFFREY.SPEAR@sakilacustomer.org         |
| KYLE       | SPURLOCK     | KYLE.SPURLOCK@sakilacustomer.org         |
| KIRK       | STCLAIR      | KIRK.STCLAIR@sakilacustomer.org          |
| ALICE      | STEWART      | ALICE.STEWART@sakilacustomer.org         |
| VERONICA   | STONE        | VERONICA.STONE@sakilacustomer.org        |
| GLEN       | TALBERT      | GLEN.TALBERT@sakilacustomer.org          |
| DOROTHY    | TAYLOR       | DOROTHY.TAYLOR@sakilacustomer.org        |
| NANCY      | THOMAS       | NANCY.THOMAS@sakilacustomer.org          |
| CLYDE      | TOBIAS       | CLYDE.TOBIAS@sakilacustomer.org          |
| PAUL       | TROUT        | PAUL.TROUT@sakilacustomer.org            |
| MARJORIE   | TUCKER       | MARJORIE.TUCKER@sakilacustomer.org       |
| CASSANDRA  | WALTERS      | CASSANDRA.WALTERS@sakilacustomer.org     |
| RUBY       | WASHINGTON   | RUBY.WASHINGTON@sakilacustomer.org       |
| YVONNE     | WATKINS      | YVONNE.WATKINS@sakilacustomer.org        |
| THERESA    | WATSON       | THERESA.WATSON@sakilacustomer.org        |
| SHEILA     | WELLS        | SHEILA.WELLS@sakilacustomer.org          |
| MITCHELL   | WESTMORELAND | MITCHELL.WESTMORELAND@sakilacustomer.org |
| FRED       | WHEAT        | FRED.WHEAT@sakilacustomer.org            |
| BETTY      | WHITE        | BETTY.WHITE@sakilacustomer.org           |
| FLORENCE   | WOODS        | FLORENCE.WOODS@sakilacustomer.org        |
| BRENDA     | WRIGHT       | BRENDA.WRIGHT@sakilacustomer.org         |
+------------+--------------+------------------------------------------+
158 rows in set (0.02 sec)











9.



+------------------+



| COUNT(rental_id) |



+------------------+



|               83 |



+------------------+



1 row in set