use sql+

Q No 2: Practical 1. Select ename , it's managers ename , dname from dept table and manager's grade from salgrade table. ENAME MANAGER_NAME MANAGER_DNAME MANAGER_GRADE JONES BLAKE CLARK ADAMS SMITH KING KING KING SCOTT FORD ACCOUNTING ACCOUNTING ACCOUNTING RESEARCH RESEARCH 5 5 5 4 4 Essentials of Oracle 97 FORD SCOTT JAMES WARD ALLEN TURNER MARTIN MILLER JONES JONES BLAKE BLAKE BLAKE BLAKE BLAKE CLARK RESEARCH RESEARCH SALES SALES SALES SALES SALES ACCOUNTING 2. Display all those employees whose manager has letter A in their name. EMP_NAME MANGER_NAM ALLEN BLAKE WARD BLAKE MARTIN BLAKE TURNER BLAKE JAMES BLAKE MILLER CLARK 3. Display employee name along with employee's grade and manager name along with manager's grade. ENAME GRADE ENAME GRADE SMITH 1 FORD JAMES 1 BLAKE ADAMS 1 SCOTT WARD 2 BLAKE MARTIN 2 BLAKE MILLER CLARK TURNER BLAKE ALLEN 3 BLAKE CLARK 4 KING BLAKE 4 KING JONES KING + Q No 2: Practical 1. Select ename , it's managers ename , dname from dept table and manager's grade from salgrade table. ENAME MANAGER_NAME MANAGER_DNAME MANAGER_GRADE JONES BLAKE CLARK ADAMS SMITH KING KING KING SCOTT FORD ACCOUNTING ACCOUNTING ACCOUNTING RESEARCH RESEARCH 5 5 5 4 4 Essentials of Oracle 97 FORD SCOTT JAMES WARD ALLEN TURNER MARTIN MILLER JONES JONES BLAKE BLAKE BLAKE BLAKE BLAKE CLARK RESEARCH RESEARCH SALES SALES SALES SALES SALES ACCOUNTING 2. Display all those employees whose manager has letter A in their name. EMP_NAME MANGER_NAM ALLEN BLAKE WARD BLAKE MARTIN BLAKE TURNER BLAKE JAMES BLAKE MILLER CLARK 3. Display employee name along with employee's grade and manager name along with manager's grade. ENAME GRADE ENAME GRADE SMITH 1 FORD JAMES 1 BLAKE ADAMS 1 SCOTT WARD 2 BLAKE MARTIN 2 BLAKE MILLER CLARK TURNER BLAKE ALLEN 3 BLAKE CLARK 4 KING BLAKE 4 KING JONES KING +