$[$PLS$,$ I NEED THE ANSWER IN $2$ HOURS CAR RENTAL SCRIPT $-$ ADDING HIERARCHY TO CUSTOMERS$-$

$--$NOTE!!!! DO NOT FORGET TO TAKE INTO ACCOUNT THE CODE BELOW, WHICH REPRESENTS HIERARCHY.; JUST THE SQL CODES; BUT KEEP IN MIND NOT TO MAKE IT TOO COMPLICATED AS I AM A BACHELOR STUDENT IN DBMS COURSE$]$ First, have a look at conceptual$/$physical model. All required is the SQL code AND screenshots of outputs of these queries in Oracle SQL Developer, but since I couldn't send the data of these tables, I just want you to write the SQL code and see all the screenshots and my descriptions in this text. Please, read carefully and make sure the queries are correct and executable:

Before extracting data, launch script below. Script creates hierarchy $($unary relation$)$ in table customer and adds data.

Alter table Customers ADD RefCust NUMBER$(6)$;

Alter table Customers

add constraint CustRefHier

Foreign Key $($RefCust$)$

References Customers$($CUSTID$)$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Zhang'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}133819\text{'})$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Zhang'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}182194\text{'})$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Martin'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}246754\text{'})$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Martin'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}285028\text{'})$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Martin'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}294827\text{'})$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Chen'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}381074\text{'})$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Chen'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}429292\text{'})$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Perez'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}482910\text{'})$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Perez'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}539118\text{'})$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Jackson'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}592937\text{'})$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Jackson'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}730282\text{'})$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Jefferson'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}876586\text{'})$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Jefferson'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}925820\text{'})$;

UPDATE Customers SET RefCust$=($Select custid FROM Customers where CUSTNAME$=$'Stewart'$)$ WHERE CUSTID$=($Select custid FROM Customers where CUSTNUM$=\text{'}956732\text{'})$;

Extract from customers:

$-$ names adding indent of $3$ "spaces" for every next level;

$-$ show customer level number in the hierarchy;

$-$ show tree path from current customer up to top customer in the hierarchy;

$-$ show only first $4$ levels of the tree.