السلام عليكم :) .. هل من مساعده ؟! :)

[ad-20-ad]

1- display the higest,lowest,sum,and average salary of all employees.Label the columns Maximum,Minimum,Sum,and average,respectively.Round your result to the nearest whole number

2- modify the query in question1 to display the manimum,maximum,sum and average salary for each job type.

3- write a query to display the number of people with the same job.

4- Determine the number of managers without listing them.Label the column number of managers.

5- write a query that will display the difference between the highest and lowest salaries.Label the column DIFFERENCE.

6- display the manager number and the salary of the lowest paid employee for that manager.exclude anyone whose manager is not known.exclude any groups where the minimum salary is lessthan 1000$.sort the output in descending order of salary.

7- write a query to display the department name,location name,number of employees,and the average salary for all employees in that department.label the columns dname,loc,number of people,and slary,respectively,round the average salary to two decimal places

[ad-20-ad]

اين انتم !؟؟!؟!؟!؟!

لديه امتحان اليوم وبقي لي هذه الاسئله ..

[ad-20-ad]

شكرن لكم ع مجاهلتي ..

[ad-20-ad]

انزين ع الاقل لو تجاوبون ع سؤال من الاسئله ارجوووووووكم ساعدوووووني

[ad-20-ad]

1- display the higest,lowest,sum,and average salary of all employees.Label the columns Maximum,Minimum,Sum,and average,respectively.Round your result to the nearest whole number

2- modify the query in question1 to display the manimum,maximum,sum and average salary for each job type.

3- write a query to display the number of people with the same job.

4- Determine the number of managers without listing them.Label the column number of managers.

5- write a query that will display the difference between the highest and lowest salaries.Label the column DIFFERENCE.

6- display the manager number and the salary of the lowest paid employee for that manager.exclude anyone whose manager is not known.exclude any groups where the minimum salary is lessthan 1000$.sort the output in descending order of salary.

7- write a query to display the department name,location name,number of employees,and the average salary for all employees in that department.label the columns dname,loc,number of people,and slary,respectively,round the average salary to two decimal places

[amr fawzy]

السلام عليكم ورحمه الله وبركاته
ياريت ياخى تحاول الاجابه على السؤال الاول والثانى فهما اسئله سهله جدا اما بخصوص السؤال الثالث فهى اجابته

select count(e1.emp)
from emp e1,emp e2
where e1.sal=e2.sal
and e1.empno<>e2.empno

وياخى ياريت تعذر الاخوه المشاركيين فقد لايكون عندهم وقت للرد على الاسئله وانا إن شاء الله ساكون معك فى باقى الاسئله
إن تيسر لى الحال وانتظر ردك فى الاجابه السابقه

[ad-20-ad]

شكرن جزييييييييييييلن لك يااخي ..

هل لك ان تكتب لي الجواب الاول والثاني لو تكرمت .!

واكون شاكرن لك ..

[UAE_Girl]

1- select sum(sal),max(sal),avg(sal), min(sal) from emp;

2-select job, sum(sal),max(sal), avg(sal) min(sal)from emp group by job;

3- select count(job) from emp;

4- select count(mgr)"Managers" from emp;

5- select max(sal)-min(sal) "Differences" from emp;



لو سمحتي يا خواني مافهمت رقم 6 و 7 هل من مساعد؟؟؟