Instruction is in the screenshot.

This is the test script:

INSERT INTO CUSTOMER $($customer$\_$id$,$ first$\_$name, last$\_$name, username, credit$\_$limit$)$ VALUES $($customer$\_$sequence.nextval,'Kelley','Engle','kmengle',$1000)$;

INSERT INTO CUSTOMER $($customer$\_$id$,$ first$\_$name, last$\_$name, username, credit$\_$limit$)$ VALUES $($customer$\_$sequence.nextval,'Rob','Schanke','rschanke',$2000)$;

INSERT INTO CUSTOMER $($customer$\_$id$,$ first$\_$name, last$\_$name, username, credit$\_$limit$)$ VALUES $($customer$\_$sequence.nextval,'Janet','Smith','jsmith',$100)$;

INSERT INTO CUSTOMER $($customer$\_$id$,$ first$\_$name, last$\_$name, username, credit$\_$limit$)$ VALUES $($customer$\_$sequence.nextval,'Yves','Gordon','ygordon',$200)$;

INSERT INTO CUSTOMER $($customer$\_$id$,$ first$\_$name, last$\_$name, username, credit$\_$limit$)$ VALUES $($customer$\_$sequence.nextval,'Bill','Clemson','bclemson',$50)$;

INSERT INTO ITEM $($item$\_$id$,$ item$\_$name, list$\_$price, date$\_$added$)$ VALUES $($item$\_$sequence.nextval,'PostgreSQL',$99\mathrm{.}98,$to$\_$date$(\text{'}1/1/2020\text{'},\text{'}$mm$/$dd$/$yyyy$\text{'}))$;

INSERT INTO ITEM $($item$\_$id$,$ item$\_$name, list$\_$price, date$\_$added$)$ VALUES $($item$\_$sequence.nextval,'Microsoft SQL Server',$199\mathrm{.}87,$to$\_$date$(\text{'}3/1/2020\text{'},\text{'}$mm$/$dd$/$yyyy$\text{'}))$;

INSERT INTO ITEM $($item$\_$id$,$ item$\_$name, list$\_$price, date$\_$added$)$ VALUES $($item$\_$sequence.nextval,'IBM DB$2\text{'},299\mathrm{.}65,$to$\_$date$(\text{'}6/1/2020\text{'},\text{'}$mm$/$dd$/$yyyy$\text{'}))$;

INSERT INTO ITEM $($item$\_$id$,$ item$\_$name, list$\_$price, date$\_$added$)$ VALUES $($item$\_$sequence.nextval,'Oracle',$989\mathrm{.}34,$to$\_$date$(\text{'}9/1/2020\text{'},\text{'}$mm$/$dd$/$yyyy$\text{'}))$;

INSERT INTO ITEM $($item$\_$id$,$ item$\_$name, list$\_$price, date$\_$added$)$ VALUES $($item$\_$sequence.nextval,$\text{'}$MySQL$\text{'},0\mathrm{.}99,$to$\_$date$(\text{'}10/1/2020\text{'},\text{'}$mm$/$dd$/$yyyy$\text{'}))$;

INSERT INTO ADDRESS $($address$\_$id$,$ customer$\_$id$,$ street, city, state, zip, phone$)$ VALUES$($address$\_$sequence.nextval,$1,\text{'}100$ Alpha DRIVE','Harrisburg',$\text{'}$PA$\text{'},\text{'}17110\text{'},\text{'}(717)555-1212\text{'})$;

INSERT INTO ADDRESS$($address$\_$id$,$ customer$\_$id$,$ street, city, state, zip, phone$)$ VALUES$($address$\_$sequence.nextval,$2,\text{'}100$ Beta DRIVE','Harrisburg',$\text{'}$PA$\text{'},\text{'}17110\text{'},\text{'}(717)555-1212\text{'})$;

INSERT INTO ADDRESS$($address$\_$id$,$ customer$\_$id$,$ street, city, state, zip, phone$)$ VALUES$($address$\_$sequence.nextval,$3,\text{'}100$ Gamma DRIVE','Harrisburg',$\text{'}$PA$\text{'},\text{'}17110\text{'},\text{'}(717)555-1212\text{'})$;

INSERT INTO ADDRESS$($address$\_$id$,$ customer$\_$id$,$ street, city, state, zip, phone$)$ VALUES$($address$\_$sequence.nextval,$4,\text{'}100$ Delta DRIVE','Harrisburg',$\text{'}$PA$\text{'},\text{'}17110\text{'},\text{'}(717)555-1212\text{'})$;

INSERT INTO ADDRESS$($address$\_$id$,$ customer$\_$id$,$ street, city, state, zip, phone$)$ VALUES$($address$\_$sequence.nextval,$5,\text{'}100$ Epsilon HACC DRIVE','Harrisburg',$\text{'}$PA$\text{'},\text{'}17110\text{'},\text{'}(717)555-1212\text{'})$;

INSERT INTO ORDER$\_$DETAIL $($customer$\_$id$,$ order$\_$id$,$ order$\_$date, order$\_$status$)$ VALUES $(1,$ order$\_$detail$\_$sequence.nextval,SYSDATE,$4)$;

INSERT INTO ORDER$\_$DETAIL $($customer$\_$id$,$ order$\_$id$,$ order$\_$date, order$\_$status$)$ VALUES $(2,$ order$\_$detail$\_$sequence.nextval,SYSDATE,$3)$;

INSERT INTO ORDER$\_$DETAIL $($customer$\_$id$,$ order$\_$id$,$ order$\_$date, order$\_$status$)$ VALUES $(3,$ order$\_$detail$\_$sequence.nextval,SYSDATE,$1)$;

INSERT INTO ORDER$\_$DETAIL $($customer$\_$id$,$ order$\_$id$,$ order$\_$date, order$\_$status$)$ VALUES $(4,$ order$\_$detail$\_$sequence.nextval,SYSDATE,$2)$;

INSERT INTO ORDER$\_$DETAIL $($customer$\_$id$,$ order$\_$id$,$ order$\_$date, order$\_$status$)$ VALUES $(5,$ order$\_$detail$\_$sequence.nextval,SYSDATE,$0)$;

INSERT INTO LINE$\_$ITEM $($order$\_$id$,$ item$\_$id$,$ quantity, discount$)$ VALUES $(1,1,1,0)$ ;

INSERT INTO LINE$\_$ITEM $($order$\_$id$,$ item$\_$id$,$ quantity, discount$)$ VALUES $(1,2,3,0)$ ;

INSERT INTO LINE$\_$ITEM $($order$\_$id$,$ item$\_$id$,$ quantity, discount$)$ VALUES $(2,4,1,0)$ ;

INSERT INTO LINE$\_$ITEM $($order$\_$id$,$ item$\_$id$,$ quantity, discount$)$ VALUES $(3,3,100,\mathrm{.}1)$ ;

INSERT INTO LINE$\_$ITEM $($order$\_$id$,$ item$\_$id$,$ quantity, discount$)$ VALUES $(4,2,1,0)$ ;

UPDATE CUSTOMER SET credit$\_$limit $=100$ WHERE CUSTOMER$\_$ID $=1$;

UPDATE ORDER$\_$DETAIL SET order$\_$status $=1$ WHERE ORDER$\_$ID $=5$;

DELETE FROM ORDER$\_$DETAIL WHERE order$\_$id $=5$;

select $*$ from customer$\_$by$\_$state;

select $*$ from customer$\_$order$\_$detail;

select $*$ from customer$\_$log;

select $*$ from order$\_$detail$\_$log;

exec simple$\_$store.purchase$\_$list;