10. Write an SQL statement that will show only the ven_name column from the vendors table Result: +-----------------------+ | ven_name | +-----------------------+ | GN FOODS | | Easy Out Inc | | OK Clothes | | Spring Cleaners | | Jason James Foods | | EK Support Inc | | George Tate Gym | | Up All Night Cleaners | | Junky Kars | | Rosy Market | +-----------------------+ 10 rows in set (0.00 sec) 11. Write an SQL statement that will show only the credit column from the vendors table Result: +---------+ | credit | +---------+ | 1000.00 | | 2500.00 | | 550.00 | | 750.00 | | 1500.00 | | 1800.00 | | 1800.00 | | 1600.00 | | 125.00 | | 1200.00 | +---------+ 10 rows in set (0.00 sec) 12. Write an SQL statement that will show only the ven_name and credit columns from the vendors table Result: +-----------------------+---------+ | ven_name | credit | +-----------------------+---------+ | GN FOODS | 1000.00 | | Easy Out Inc | 2500.00 | | OK Clothes | 550.00 | | Spring Cleaners | 750.00 | | Jason James Foods | 1500.00 | | EK Support Inc | 1800.00 | | George Tate Gym | 1800.00 | | Up All Night Cleaners | 1600.00 | | Junky Kars | 125.00 | | Rosy Market | 1200.00 | +-----------------------+---------+ 10 rows in set (0.00 sec) 13. Write an SQL statement that will show all the columns from the products table Result: +-------------------+--------+ | PRODUCT_NAME | PRICE | +-------------------+--------+ | Hammer | 12.99 | | Stove | 399.99 | | Nails | 1.99 | | Mirror | 300.99 | | Lights | 10.99 | | Shelves | 59.99 | | Gas Range | 599.99 | | Electric Heater | 29.99 | | Repair Manual | 15.99 | | Floor Tiles | 39.98 | | Washer | 199.95 | | Dryer | 299.95 | | Sink | 87.99 | | 2X4 | 10.50 | | Sofa | 234.95 | | Couch | 495.99 | | Sofa Cover | 49.95 | | Wood Glue | 8.75 | | Tomato Plans | 2.99 | | Red Roses | 24.95 | | 1 GB RAM | 59.95 | | WD 1TB Hard Drive | 100.99 | | CD ROM | 34.99 | +-------------------+--------+ 23 rows in set (0.00 sec) 14. Write an SQL statement that will show only the product_name column from the products table Result: +-------------------+ | product_name | +-------------------+ | Hammer | | Stove | | Nails | | Mirror | | Lights | | Shelves | | Gas Range | | Electric Heater | | Repair Manual | | Floor Tiles | | Washer | | Dryer | | Sink | | 2X4 | | Sofa | | Couch | | Sofa Cover | | Wood Glue | | Tomato Plans | | Red Roses | | 1 GB RAM | | WD 1TB Hard Drive | | CD ROM | +-------------------+ 23 rows in set (0.00 sec) 15. Write an SQL statement that will show only the product_name and price columns from the products table Result: +-------------------+--------+ | product_name | price | +-------------------+--------+ | Hammer | 12.99 | | Stove | 399.99 | | Nails | 1.99 | | Mirror | 300.99 | | Lights | 10.99 | | Shelves | 59.99 | | Gas Range | 599.99 | | Electric Heater | 29.99 | | Repair Manual | 15.99 | | Floor Tiles | 39.98 | | Washer | 199.95 | | Dryer | 299.95 | | Sink | 87.99 | | 2X4 | 10.50 | | Sofa | 234.95 | | Couch | 495.99 | | Sofa Cover | 49.95 | | Wood Glue | 8.75 | | Tomato Plans | 2.99 | | Red Roses | 24.95 | | 1 GB RAM | 59.95 | | WD 1TB Hard Drive | 100.99 | | CD ROM | 34.99 | +-------------------+--------+ 23 rows in set (0.01 sec)