اسئلة تبحث عن حلول... الرجاءالمساعدة

السلام عليكم هاي اسئلة مقترحة لامتحان الاوركل بس بدي حلولهم للضرورة القصوى .... الرجاء المساعدة


1. Create a query to display the name, salary, and commission for all employees whose commission is greater than their salary increased by 10%


2. Display name, hire date, and salary review; which is the first Monday after six months of service. Label the column REVIEW. Format the dates to appear in the format similar to “Sunday, the Seventh of September 1997”.



3. Display the name and number for all employees along with their manager’s name and manager number. Display “No Manager” if the employee does not have a manger. Label the columns Employee, Emp #, Manager, and Mgr #, respectively.


4. Display all employee’s name and hire date along with their manager’s name and hire date for all employees who were hired before their managers. Label the columns Employee, Emp Hiredate, Manager, Mgr Hiredate, respectively.


5. Create a query to display the job id, the salary for that job based on department number, and the total salary for that job for all departments. The output will look like:
Job ID Dept 10 Dept 20 Dept 30 Total
---------- --------- --------- ---------- ------
1234 0 6000 0 6000
5678 1300 1900 1300 4150
…