p. 137 - creating a new table select employee_id, first_name, last_name, dept_code from l_employees where dept_code = 'sal' order by employee_id; select employee_id, first_name, last_name, dept_code into sec0401_sales_staff from l_employees where dept_code = 'sal'; Select * from sec0401_sales_staff order by employee_id; p. 141 Saving a View/query select employee_id, first_name, last_name, dept_code from l_employees where dept_code = 'sal' order by employee_id; p. 142 - tables vs. views select * from sec0401_sales_staff; select * from sec0402_sales_staff_view; p. 144 deleting a table drop table sec0405_sales_staff; p. 148-149 Building on a vew/query select employee_id, first_name, last_name, dept_code from l_employees where dept_code = 'sal'; select employee_id, first_name, last_name from sec0407_sales_staff_view1 where employee_id <=208; select * from sec0407_sales_Staff_view2; p. 152 adding a row to a table insert into sec0409_foods values ('ARR', 'AP', 11, 'APPLE PIE', 1.50, null); insert into sec0409_foods (product_code, description, supplier_id, price) values ('BP', 'BLUEBERRY PIE', 'ARR', 1.60); p. 155 adding several rows to a table insert into sec0410a_foods (supplier_id, product_code, menu_item, description) select 'ARR', product_code, menu_item, description from sec0410_foods where supplier_id = 'ASP'; p. 158 updating existing values in a table update sec0411_foods set price = price + 0.10, price_increase = price_increase + 0.10 where supplier_id in ('JBR', 'FRV'); p. 160 deleting rows from a table delete from sec0412_foods where supplier_id in ('CBC', 'JBR'); p. 168 Example of constraints update sec0415_employees set phone_number = '3484' where employee_id = 202; update l_employees set phone_number = '3484' where employee_id = 202;