
DROP TABLE IF EXISTS purchase_orders;

CREATE TABLE purchase_orders ( po_id INTEGER, cust_id INTEGER, purchase_date date, purchase_subtotal DECIMAL(8,2), purchase_tax DECIMAL(8,2), purchase_bill DECIMAL(8,2));

INSERT INTO purchase_orders 
VALUES (12500,1000,'12-01-2021',60.00,6.00,66.00);
INSERT INTO purchase_orders 
VALUES (12600,1000,'02-03-2022',30.00,3.00,33.00);
INSERT INTO purchase_orders 
INSERT VALUES (12700,1000,'05-07-2022',80.00,8.00,88.00);

