Using the northwind database, write SQL statements to:

categories 123 category_id ADC category_name ABC description picture employee_territories 123 employee_id noc territory_id E products 123 product_id ADC product_name 123 supplier_id 123 category_id ADC quantity_per_unit 123 unit_price 123 units_in_stock 123 units_on_order 123 reorder_level 123 discontinued suppliers 123 supplier_id ADC company name ADC contact name ADC contact_title AC address AC City ABC region ABC postal code AC country noc phone Ac fax Anc homepage employees 123 employee_id AC last name ABC first_name ADC title Actitle_of_courtesy birth_date hire_date AC address ABC City AC region ABC postal code Accountry AC home_phone ADC extension D photo ADC notes 123 reports_to ADC photo_path territories ac territory_id ADC territory_description 123 region_id region 123 region_id RDC region_description order_details 123 order_id 123 product_id 123 unit_price 123 quantity 123 discount customers ADC customer_id ABC company name ADC contact name ADC contact_title AC address Ac city Borders 123 order_id AC customer_id 123 employee_id orderd required_date shipped date 123 ship via 123 freight AC ship name AC ship address ac ship_city ABC ship region ADC Ship postal code ABC ship country ADC region Bus states BB customer customer_demo ADC customer_id ADC customer_type_id ADC postal code ABC country ABC phone ADC fax shippers 123 shipper_id ABC company name Ac phone 123 state id noc state_name ADC state_abbr ADC state region 3 customer_demographics ADC customer_type_id ADC customer desc 7. Update the database after Robert Zare was promoted to Sales Manager 8. Get the date and id of all orders placed during April 2006. categories 123 category_id ADC category_name ABC description picture employee_territories 123 employee_id noc territory_id E products 123 product_id ADC product_name 123 supplier_id 123 category_id ADC quantity_per_unit 123 unit_price 123 units_in_stock 123 units_on_order 123 reorder_level 123 discontinued suppliers 123 supplier_id ADC company name ADC contact name ADC contact_title AC address AC City ABC region ABC postal code AC country noc phone Ac fax Anc homepage employees 123 employee_id AC last name ABC first_name ADC title Actitle_of_courtesy birth_date hire_date AC address ABC City AC region ABC postal code Accountry AC home_phone ADC extension D photo ADC notes 123 reports_to ADC photo_path territories ac territory_id ADC territory_description 123 region_id region 123 region_id RDC region_description order_details 123 order_id 123 product_id 123 unit_price 123 quantity 123 discount customers ADC customer_id ABC company name ADC contact name ADC contact_title AC address Ac city Borders 123 order_id AC customer_id 123 employee_id orderd required_date shipped date 123 ship via 123 freight AC ship name AC ship address ac ship_city ABC ship region ADC Ship postal code ABC ship country ADC region Bus states BB customer customer_demo ADC customer_id ADC customer_type_id ADC postal code ABC country ABC phone ADC fax shippers 123 shipper_id ABC company name Ac phone 123 state id noc state_name ADC state_abbr ADC state region 3 customer_demographics ADC customer_type_id ADC customer desc 7. Update the database after Robert Zare was promoted to Sales Manager 8. Get the date and id of all orders placed during April 2006