Part 3: DML - Inserting Data We will just experiment with adding \& updating data in the PRICE table. (Next week, I will give you the code to insert data for all tables.) Camula af tha DRiCE tahle data 13. Write an INSERT statement to add the row (5, 'Member Loyalty', 0,.5) to PRICE. 14. Write an INSERT statement for the same data but data values given in a different order (5,0,.5, 'Member Loyalty') to PRICE. 15. Write an INSERT statement to add the row (6, 'Employee Discount') to PRICE (example of inserting with some data missingl. 16. Write an UPDATE statement to increase all price rental fee values in the PRICE table by $0.50. 17. Write an UPDATE statement to change the price description of 'Standard' to 'Regular Rate'. \{you have to use a where clause here - we really haven't talked about that yet so just do your best. } 18. Write the statement to delete price code 4. \{again, you need a where clause here\}. 19. Write the statement that deletes all the data in the PRICE table. 20. What command is used to delete a Table - not the data in a table but an entire table? Part 3: DML - Inserting Data We will just experiment with adding \& updating data in the PRICE table. (Next week, I will give you the code to insert data for all tables.) Camula af tha DRiCE tahle data 13. Write an INSERT statement to add the row (5, 'Member Loyalty', 0,.5) to PRICE. 14. Write an INSERT statement for the same data but data values given in a different order (5,0,.5, 'Member Loyalty') to PRICE. 15. Write an INSERT statement to add the row (6, 'Employee Discount') to PRICE (example of inserting with some data missingl. 16. Write an UPDATE statement to increase all price rental fee values in the PRICE table by $0.50. 17. Write an UPDATE statement to change the price description of 'Standard' to 'Regular Rate'. \{you have to use a where clause here - we really haven't talked about that yet so just do your best. } 18. Write the statement to delete price code 4. \{again, you need a where clause here\}. 19. Write the statement that deletes all the data in the PRICE table. 20. What command is used to delete a Table - not the data in a table but an entire table