Select Command Lab Directions: Using the TEE command record you commands to these questions. Store your answers in a file named M2U1A1.txt on your flash drive

6. Write an SQL statement that will show only the city and state columns from the employees table Result: +-------------+-------+ | city | state | +-------------+-------+ | Allen | NY | | Allen | SD | | Humming | OH | | Hastings | TN | | Humming | OH | | Humming | OH | | Humming | OH | | Allen | SD | | Corneth | NY | | Westbridge | TN | | Lane | KY | | Lane | KY | | South | KY | | Kidd | SD | | Foto | NY | | Cake | KY | | Allen | SD | | South | KY | | Egg | FL | | Kow | TX | | Tempus | FL | | Gadzooks | KY | | Town | KY | | Henry | MI | | Sunny | KY | | Logan | WV | | Town | KY | | Sol | KY | | Little John | WV | | Bruce | VA | +-------------+-------+ 30 rows in set (0.00 sec) 7. Write an SQL statement that will show only the address, city, and state columns from the employees table Result: +-------------------+-------------+-------+ | address | city | state | +-------------------+-------------+-------+ | 123 Main | Allen | NY | | 23 South Lane | Allen | SD | | Route 12 | Humming | OH | | 12 Mocking Ln | Hastings | TN | | 78 West Ave | Humming | OH | | 78 West Street | Humming | OH | | 83 West Street | Humming | OH | | 12 West Road | Allen | SD | | 57th Street | Corneth | NY | | 83rd Street | Westbridge | TN | | 23rd Front Street | Lane | KY | | 34 West Road | Lane | KY | | 102 North Road | South | KY | | 12 South Road | Kidd | SD | | 12 Main Street | Foto | NY | | PO BOX 282 | Cake | KY | | 17 West Street | Allen | SD | | 293 West Ave | South | KY | | 34 Chicken Street | Egg | FL | | 22 LG Drive | Kow | TX | | 87 Glory Road | Tempus | FL | | 23 Western Lane | Gadzooks | KY | | 11 East Street | Town | KY | | 1st Lane | Henry | MI | | 23 Green Valley | Sunny | KY | | Route 12 | Logan | WV | | Route 234 | Town | KY | | 12 Glass Road | Sol | KY | | Route 23 | Little John | WV | | 39 South Bend | Bruce | VA | +-------------------+-------------+-------+ 30 rows in set (0.00 sec) 8. Write an SQL statement that will show all the columns from the employees table Result: mysql> select * from employees; +---------+----------+-----------+-------------------+-------------+-------+-------+ | EMP_NUM | EMP_LAST | EMP_FIRST | ADDRESS | CITY | STATE | ZIP | +---------+----------+-----------+-------------------+-------------+-------+-------+ | 1 | MorriS | Tony | 123 Main | Allen | NY | 23412 | | 2 | Smith | Paula | 23 South Lane | Allen | SD | 08262 | | 3 | Clark | Jenny | Route 12 | Humming | OH | 23576 | | 4 | Frank | Dave | 12 Mocking Ln | Hastings | TN | 83723 | | 5 | Stevens | April | 78 West Ave | Humming | OH | 23577 | | 6 | Kennedy | Lawance | 78 West Street | Humming | OH | 23578 | | 7 | Peters | Perry | 83 West Street | Humming | OH | 23578 | | 8 | Chenny | Terry | 12 West Road | Allen | SD | 08932 | | 9 | Clark | Hellen | 57th Street | Corneth | NY | 98756 | | 10 | Stevens | Jack | 83rd Street | Westbridge | TN | 83498 | | 11 | Williams | John | 23rd Front Street | Lane | KY | 45234 | | 12 | Hall | Colleen | 34 West Road | Lane | KY | 45234 | | 13 | Smith | Dorra | 102 North Road | South | KY | 42142 | | 14 | Bennet | June | 12 South Road | Kidd | SD | 08332 | | 15 | Quinn | Laura | 12 Main Street | Foto | NY | 90832 | | 16 | Rain | Murry | PO BOX 282 | Cake | KY | 49872 | | 17 | Holmes | Cora | 17 West Street | Allen | SD | 19836 | | 18 | Tate | Remus | 293 West Ave | South | KY | 42142 | | 19 | Tate | Romus | 34 Chicken Street | Egg | FL | 78764 | | 20 | Moore | Misha | 22 LG Drive | Kow | TX | 67654 | | 21 | Cook | Anne | 87 Glory Road | Tempus | FL | 79832 | | 22 | Franks | Tim | 23 Western Lane | Gadzooks | KY | 41832 | | 23 | Dylan | Jane | 11 East Street | Town | KY | 44323 | | 24 | Crane | lee | 1st Lane | Henry | MI | 55343 | | 25 | Green | Lenny | 23 Green Valley | Sunny | KY | 43233 | | 26 | Ellis | Steve | Route 12 | Logan | WV | 62323 | | 27 | Lance | Tim | Route 234 | Town | KY | 44323 | | 28 | Jackson | Dylan | 12 Glass Road | Sol | KY | 49873 | | 29 | South | Mora | Route 23 | Little John | WV | 62345 | | 30 | Prince | Paul | 39 South Bend | Bruce | VA | 12938 | +---------+----------+-----------+-------------------+-------------+-------+-------+ 30 rows in set (0.01 sec) 9. Write an SQL statement that will show all the columns from the vendors table Result: +----------+-----------------------+---------+ | VEN_CODE | VEN_NAME | CREDIT | +----------+-----------------------+---------+ | 01 | GN FOODS | 1000.00 | | 02 | Easy Out Inc | 2500.00 | | 03 | OK Clothes | 550.00 | | 04 | Spring Cleaners | 750.00 | | 05 | Jason James Foods | 1500.00 | | 06 | EK Support Inc | 1800.00 | | 07 | George Tate Gym | 1800.00 | | 08 | Up All Night Cleaners | 1600.00 | | 09 | Junky Kars | 125.00 | | 10 | Rosy Market | 1200.00 | +----------+-----------------------+---------+ 10 rows in set (0.00 sec)