السلام عليكم

محتاجه مساعدتكم في حل الاسئلة


هذي الجداول

http://www.hello-iraq.com/up/up/23012412620081224.jpg
--

http://www.hello-iraq.com/up/up/23012426220081224.jpg
--
http://www.hello-iraq.com/up/up/23012431720081224.gif
--
retrierne first-name ,last-name,and salary for any
employee where his salary is>min-salary and <max-salary.
..
write the statement
the no>of
employee=??
..
write the statement
the no.of employee having the
job-id=2=??

الله يجزاكم الجنة

محتاجه حل الاسئلة

كـود SQL

select first-name ,last-name, salary from employees
where salary between (select min (salary) from employeess) and (select max(salary) from employees)

select count(emploee_id) from employees

هذا اذا كان المطلوب عدد الموظفين كيفما فهمت

تم تعديل 24 ديسمبر 200817 سنة بواسطة Essamshabeeb

select first-name ,last-name, salary from employees where salary between (select min (salary) from employeess) and (select max(salary) from employees)

مرة اخرى السؤال الاول

write the statement
the no.of employee having the
job-id=2=??

select count(emploee_id) from employees where job_id = 2

الله يجزاك الجنه و نعيمها

و يوفقك دنيا و اخرة

ويفرج لك

شكرا شكرا