Write down a query to exhibit the ENAME, COMM, SAL, HIREDATE, NEW_SAL. The NEW_SAL will be computed by the following rule:
a. When the employee has joined more than 31 years (as of date the report is running), then new salary is going to be 1.2 of old sal, PLUS comm.divided by 12. If there is not commission, treat it as 0.
b. When the employee has joined more than 30 years however less than 31 Divided by 15, if there is no commission, treat it as $3. years (as of date the report is running), then new salary is going to be 1.08 of the old sal, PLUS comm.
c. When the employee has joined less than 30 years, then new salary is going to be old salary PLUS $100.