(DBMS):

Write SQLyog Queries:

1. List all employees’ number, employee’s name and jobs from emp.
2. List all employees’ number, employee’s name and jobs from emp whose salaries greater than 5,000.
3. List all employees’ number, employee’s name and jobs from emp whose salaries less than 5,000.
4. List all employees’ number, employee’s name and jobs from emp whose salaries between 1,000 to 5,000.
5. List all employees’ number, employee’s name, jobs and salaries from emp.

Emp_num	Emp_Name	Emp_Job	Emp_Sal
E101	Salman	Analyst	6000
E102	Bushra	Programmer	5000
E103	Madiha	Web Designer	6000
E104	Batool	ERD designer	4000
E105	Hameed	Web Designer	3000
E106	Nini	Analyst	2500
E107	Imtiaz	Web Designer	6500
E108	Rashid	Programmer	4000
E109	Muzzamil	ERD designer	2000

Answer rating: 100% (QA)

1 SELECT EmpnumEmpnameEmpjob from emp The syntax is SELECT ... View the full answer