SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete create table l_employees (employee_id varchar2(50) not null, first_name varchar2(50), last_name varchar2(50), dept_code varchar2(50), hire_date date, credit_limit number(10,2), phone_number varchar2(50), manager_id varchar2(50), constraint l_employees_pk primary key (employee_id)); insert into l_employees (employee_id , first_name , last_name , dept_code , hire_date , credit_limit , phone_number , manager_id ) values ('201', 'Susan', 'Brown', 'Exe', to_date ('06/01/1992', ' mm/dd yyyy '), 30.00, '3484', ''); insert into l_employees (employee_id , first_name , last_name , dept_code , hire_date , credit_limit , phone_number , manager_id ) values ('202', 'Jim', 'Kern', 'Sal', to_date ('08/15/1995','mm/dd/yyyy'), 25.00, '8722', '201'); insert into l_employees (employee_id , first_name , last_name , dept_code , hire_date , credit_limit , phone_number , manager_id ) values ('203', 'Martha', 'Woods', 'Shp', to_date ('02/01/1997', ' mm/dd/yyyy '), 25.00, '7591', '201'); insert into l_employees (employee_id , first_name , last_name , dept_code , hire_date , credit_limit , phone_number , manager_id ) values ('204', 'Ellen', 'Owens', 'Sal', to_date ('07/01/1996', ' mm/dd/yyyy '), 15.00, '6830', '202'); insert into l_employees (employee_id , first_name , last_name , dept_code , hire_date , credit_limit , phone_number , manager_id ) values ('205', 'Henry', 'Perkins', 'Sal', to_date ('03/01/1998', ' mm/dd/yyyy '), 25.00, '5286', '202'); insert into l_employees (employee_id , first_name , last_name , dept_code , hire_date , credit_limit , phone_number , manager_id ) values ('206', 'Carol', 'Rose', 'Act', to_date ('10/15/1997', ' mm/dd/yyyy '), 15.00, '3829', '201'); insert into l_employees (employee_id , first_name , last_name , dept_code , hire_date , credit_limit , phone_number , manager_id ) values ('207', 'Dan', 'Smith', 'Shp', to_date ('12/01/1996', ' mm/dd/yyyy '), 25.00, '2259', '203'); insert into l_employees (employee_id , first_name , last_name , dept_code , hire_date , credit_limit , phone_number , manager_id ) values ('208', 'Fred', 'Campbell', 'Shp', to_date ('04/01/1997', ' mm/dd/yyyy '), 25.00, '1752', '203'); insert into l_employees (employee_id , first_name , last_name , dept_code , hire_date , credit_limit , phone_number , manager_id ) values ('209', 'Paula', 'Jacobs', 'Mkt', to_date ('03/17/1998', ' mm/dd/yyyy '), 15.00, '3357', '201'); insert into l_employees (employee_id , first_name , last_name , dept_code , hire_date , credit_limit , phone_number , manager_id ) values ('210', 'Nancy', 'Hoffman', 'Sal', to_date ('02/15/1996', ' mm/dd/yyyy '), 25.00, '2974', '203'); create table l_foods (supplier_id varchar2(50), product_code varchar2(50), menu_item number(10), description varchar2(50), price number(10,2), price_increase varchar2(20), constraint l_foods_pk primary key (supplier_id, product_code)); insert into l_foods (supplier_id, product_code, menu_item, description, price, price_increase) values('ASP','FS', 1, 'FRESH SALAD', 2.00, '$0.25'); insert into l_foods (supplier_id, product_code, menu_item, description, price, price_increase) values('ASP','SP', 2, 'SOUP OF THE DAY', 1.50,''); insert into l_foods (supplier_id, product_code, menu_item, description, price, price_increase) values('ASP','SW', 3, 'SANDWICH', 3.50, '$0.40'); insert into l_foods (supplier_id, product_code, menu_item, description, price, price_increase) values('CBC','GS', 4, 'GRILLED STEAK', 6.00, '$0.70'); insert into l_foods (supplier_id, product_code, menu_item, description, price, price_increase) values('CBC','SW', 5, 'HAMBURGER', 2.00, '$0.30'); insert into l_foods (supplier_id, product_code, menu_item, description, price, price_increase) values('FRV','BR', 6, 'BROCCOLI', 1.00, '$0.05'); insert into l_foods (supplier_id, product_code, menu_item, description, price, price_increase) values('FRV','FF', 7, 'FRESH FRIES', 1.50, ''); insert into l_foods (supplier_id, product_code, menu_item, description, price, price_increase) values('JBR','AS', 8, 'SODA', 1.25, '$0.25'); insert into l_foods (supplier_id, product_code, menu_item, description, price, price_increase) values('JBR','VR', 9, 'COFFEE', 0.85, '$0.15'); insert into l_foods (supplier_id, product_code, menu_item, description, price, price_increase) values('VSB','AS', 10, 'DESERT', 3.00, '$0.50'); create table l_lunch_items (lunch_id number(10), item_number number(10), supplier_id varchar2(50), product_code varchar2(50), quantity number(10)); insert into l_lunch_items (lunch_id, item_number, supplier_id, product_code, quantity) values(1,1, 'ASP', 'FS', 1); insert into l_lunch_items (lunch_id, item_number, supplier_id, product_code, quantity) values(1,2, 'ASP', 'SW', 2); insert into l_lunch_items (lunch_id, item_number, supplier_id, product_code, quantity) values(1,3, 'JBR', 'VR', 2); insert into l_lunch_items (lunch_id, item_number, supplier_id, product_code, quantity) values(2,1, 'ASP', 'SW', 2); insert into l_lunch_items (lunch_id, item_number, supplier_id, product_code, quantity) values(2,2, 'FRV', 'FF', 1); insert into l_lunch_items (lunch_id, item_number, supplier_id, product_code, quantity) values(2,3, 'JBR', 'VR', 2); insert into l_lunch_items (lunch_id, item_number, supplier_id, product_code, quantity) values(2,4, 'VSB', 'AS', 1); insert into l_lunch_items (lunch_id, item_number, supplier_id, product_code, quantity) values(3,1, 'ASP', 'FS', 1); insert into l_lunch_items (lunch_id, item_number, supplier_id, product_code, quantity) values(3,2, 'CBC', 'GS', 1); insert into l_lunch_items (lunch_id, item_number, supplier_id, product_code, quantity) values(3,3, 'FRV', 'FF', 1); insert into l_lunch_items (lunch_id, item_number, supplier_id, product_code, quantity) values(3,4, 'JBR', 'VR', 1); insert into l_lunch_items (lunch_id, item_number, supplier_id, product_code, quantity) values(3,5, 'JBR', 'AS', 1);