Q1. Please wrrite. a query statement from emp table for all employees to display employee's name, job, and name_length. The name_length must be less than or equal to 5 characters. Label the column heading to ENAME, JOB, and NAME_LENGTH. Order your results by the length of ename descending order. The result should be like below:
[image below - scr_Q1.png]
Q2)
Please write .a query statement from emp table to display deptno 30’s ename, deptno, sal, and sal_format for all employees. Format the sal_format to be 15 characters long with a left-padded $. Order your results by the sal column. Label the column headingto ENAME, DEPTNO, SAL, and SAL_FORMAT. The result should be like below:
[image brlow - scr_Q2.png]
Here is the material needed to answer those questions:
Material:
- https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing
- https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing
Extracted text: SQL> SELECT ename, deptno, sal, . FROM emp WHERE ORDER BY ...; ENAME DEPTNO SAL SAL_FORMAT JAMES 30 950 $$$$$$$$$$$$950 MARTIN 30 1250 $$$$$$$$$$$1250 WARD 30 1250 $$$$$$$$$$$1250 TURNER 30 1500 $$$$$$$$$$$1500 ALLEN 30 1600 $$$$$$$$$$$1600 BLAKE 30 2850 $$$$$$$$$$$2850
Extracted text: SQL> SELECT ename, job, FROM emp WHERE ORDER BY ...; ENAME JOB NAME_LENGTH BLAKE MANAGER CLARK MANAGER ALLEN SALESMAN ADAMS CLERK JAMES CLERK JONES MANAGER SCOTT ANALYST SMITH CLERK FORD ANALYST 4 KING PRESIDENT 4 WARD SALESMAN 4