Question: Database table - employees emp_id | emp_name | job_name | manager_id | hire_date | salary | commission | dep_id --------+----------+-----------+------------+------------+---------+------------+-------- 68319 | KAYLING | PRESIDENT

Database table - employees emp_id | emp_name | job_name | manager_id | hire_date | salary | commission | dep_id --------+----------+-----------+------------+------------+---------+------------+-------- 68319 | KAYLING | PRESIDENT | | 1991-11-18 | 6000.00 | | 1001 66928 | BLAZE | MANAGER | 68319 | 1991-05-01 | 2750.00 | | 3001 67832 | CLARE | MANAGER | 68319 | 1991-06-09 | 2550.00 | | 1001 65646 | JONAS | MANAGER | 68319 | 1991-04-02 | 2957.00 | | 2001 67858 | SCARLET | ANALYST | 65646 | 1997-04-19 | 3100.00 | | 2001 69062 | FRANK | ANALYST | 65646 | 1991-12-03 | 3100.00 | | 2001 63679 | SANDRINE | CLERK | 69062 | 1990-12-18 | 900.00 | | 2001 64989 | ADELYN | SALESMAN | 66928 | 1991-02-20 | 1700.00 | 400.00 | 3001 65271 | WADE | SALESMAN | 66928 | 1991-02-22 | 1350.00 | 600.00 | 3001 66564 | MADDEN | SALESMAN | 66928 | 1991-09-28 | 1350.00 | 1500.00 | 3001 68454 | TUCKER | SALESMAN | 66928 | 1991-09-08 | 1600.00 | 0.00 | 3001 68736 | ADNRES | CLERK | 67858 | 1997-05-23 | 1200.00 | | 2001 69000 | JULIUS | CLERK | 66928 | 1991-12-03 | 1050.00 | | 3001 69324 | MARKER | CLERK | 67832 | 1992-01-23 | 1400.00 | | 1001 1. single column SELECT emp_id from employees; 2. multiple colums SELECT emp_id, emp_name from employees; 3. all SELECT * from employees; 4 WHERE (who joined in month of jan) SELECT * FROM employees WHERE to_char(hire_date, 'mon')='jan'; 5 AND ( List the employees who are SALESMAN and gathered an experience which month portion is more than 10.) SELECT * FROM employees WHERE job_name = 'SALESMAN' AND EXTRACT(MONTH FROM age(CURRENT_DATE, hire_date)) > 10; 6. OR ( list the employees of department id 3001 or 1001 joined in the year 1991 ) SELECT * FROM employees WHERE to_char(hire_date,'YYYY') = '1991' AND (dep_id =3001 OR dep_id =1001) ; 7. IN ( Write a query in SQL to list the employees who does not belong to department 2001. ) SELECT * FROM employees WHERE dep_id NOT IN (2001); 8 . BETWEEN ( Write a query in SQL to list the employees, joined in the month FEBRUARY with a salary range between 1001 to 2000. ) SELECT * FROM employees WHERE to_char(hire_date,'MON') = 'FEB' AND salary BETWEEN 1000 AND 2000; 9. ORDER Write a query in SQL to list the employees in the descendingorder of their salaries SELECT * FROM employees ORDER BY salary DESC; 10. TOP SELECT TOP 5 emp_name FROM employees; 11. UNIQUE ( . Write a query in SQL to display the unique designations for the employees. ) SELECT DISTINCT job_name FROM employees; 12. Write a query in SQL to list the employees name, department, salary and commission. For those whose salary is between 2000 and 5000 while location is PERTH SELECT e.emp_name, e.dep_id, e.salary, e.commission FROM employees e, department d WHERE e.dep_id = d.dep_id AND d.dep_location = 'PERTH' AND e.salary BETWEEN 2000 AND 5000; The top one is employee table, query has been already run for all the questions, I just need need screenshot of all query once you run it. Screenshot has to be of full screen of run SQL page

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!