Question: Database Management Systems INT300 Lab Sheet#1: Single Table SQL Wednesday, June 16, 2021 job Bonus NULL 7788 1983-01-12 1100 . NULL 20 20 7839 7698

Database Management Systems INT300 Lab Sheet#1: Single Table SQL Wednesday, June 16, 2021 job Bonus NULL 7788 1983-01-12 1100 . NULL 20 20 7839 7698 1981-02-20 1600 300 30 30 1500 30 1981-12-03 2450 7934 NULL Exercises Consider the following EMPLOYEE table: EMPLOYEE Emp_no Name Boss Hiredate Salary Dept no 7839 KING PRESIDENT 1981-11-17 5000 NULL 10 7566 JONES MANAGER 7839 1981-04-02 2975 NULL 20 7788 SCOTT ANALYST 7566 1982-12-09 3000 NULL 20 7876 ADAMS CLERK NULL 20 7902 FORD ANALYST 7566 1981-12-03 3000 7369 SMITH CLERK 7902 1980-12-17 800 NULL 7698 BLAKE MANAGER 1981-05-01 2850 NULL 30 7499 ALLEN SALESMAN 7521 WARD SALESMAN 7698 1981-02-22 1250 500 7654 MARTIN SALESMAN 7698 1981-09-28 1250 1400 30 7844 TURNER SALESMAN 7698 1981-09-08 0 7900 JAMES CLERK 7698 950 NULL 30 7782 CLARK MANAGER 7839 1981-06-09 NULL 10 MILLER CLERK 7782 1982-01-23 1300 10 ET: Write SQL query that list the name of all employees who work in department 20. E2: Write SQL query that list the name of all employees whose salary is greater than 2000 and work in department 20. E3: Write SQL query that list the name of all employees who were hired in September. E4: Write SQL query that list the name of all employees with no bonus ES: Write SQL query that list the name of the manager with the highest salary E6: Write SQL query that list the total, average, max, and min salary E7: Write SQL query that list the average, max, and min salary in cach department ES: Write SQL query that list the number of employees who work as managers E9: Write SQL query that list the Job and the number of employees with that job. E10 Write SQL query that list the maximum salary for each job EIT: Write SQL query that list the job type and the number of employees with that job type in department 30 E12: Write SQL query that list the average salary for employees who work as managers. EI3: Write SQL query that list the department No of all departments with more than two employees E14 Write SQL query that list the number of employees in each department with a bonus greater than 400 ETS: Write SQL query that list the department number and the number of employees for departments where the average bonus is greater than 400

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 General Management Questions!

Populate.sql: Please show with steps on cmd SQL format Rem ******** dropping tables ************* DROP TABLE SALGRADE; DROP TABLE EMPLOYEE; DROP TABLE DEPT; Rem ******** create table DEPT...

-- THIS IS THE FAMOUS ORACLE DEMO DATABASEEXAMPLE -- I GAVE YOU THE DDL TO CREATE 4 TABLES (ACTUALLY, YOU ARE USING MOSTLY TWO OF THEM) -- READ THE CREATE TABLE STATMENTS AND THE INSERT STATEMENTS TO...

Start SQL*Plus database: CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2)); INSERT...

--SQL DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE BONUS; DROP TABLE SALGRADE; CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL...

database Consider the following two tables: DEPARTMENT Dept_no Dept_name 10 ACCOUNTING 20 RESEARCH 30 SALES 40 OPERATIONS Location NEW YORK DALLAS CHICAGO BOSTON Salary 5000 2975 3000 1100 3000...

Database Mgmt sytms Use the Scott database to write the following query List the project_no for projects that started in 2006 and has more than two employees. Hint: Use the PROJECT and WORKS_ON...

Unit 5 Lab - SQL statements - Need help on these Database Below: CREATE TABLE DEMO_DEPT (DEPTNO NUMBER(2) CONSTRAINT pk_dept PRIMARY KEY, DNAME VARCHAR2(14), LOC VARCHAR2(13) ); INSERT INTO DEMO_DEPT...

Hello, I am taking an Intro to Database Management Course and there are a few queries that I need help on for an assignment. I have posted the SQL code that the instructor wants us to work with and...

This case describes a situation where a company overstated its recorded expenses in 1996 (as compared to understating recorded expenses). Why would a company choose to overstate its expenses and...

Businesses today are expected to have a website and online presence as standard practice. But websites can be damaging to a business if not done properly. List 3 possible ways that a business can be...

ABC has issued a $1000 par bond with 25 years to maturity, 7% coupon rate, and semi-annual payments. Calculate the present value if the bond if the YTM is 7%. How would the answer to #1 change if the...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...