Question: Write the sql queries to Insert the data as per the table created below EMP Table COMM 300 500 EMPNO 7369 7499 7521 7566 7654

Write the sql queries to Insert the data as per the table created below

EMP Table COMM 300 500 EMPNO 7369 7499 7521 7566 7654 7698 7782 7788 7839 7844 7876 7900 7902 7934 1400 ENAME SMITH ALLEN WARD JONES MARTIN BLAKE CLARK SCOTT KING TURNER ADAMS JAMES FORD MILLER JOB CLERK SALESMAN SALESMAN MANAGER SALESMAN MANAGER MANAGER ANALYST PRESIDENT SALESMAN CLERK CLERK ANALYST CLERK MGR 7902 7698 7698 7839 7698 7839 7839 7566 HIREDATE 17-DEC-80 20-FEB-81 22-FEB-81 02-APR-81 28-SEP-81 01-MAY-81 09-JUN-81 19-APR-87 17-NOV-81 08-SEP-81 23-MAY-87 03-DEC-81 03-DEC-81 23-JAN-82 SAL 800 1600 1250 2975 1250 2850 2450 3000 5000 1500 1100 950 3000 1300 DEPTNO 20 30 30 20 30 30 10 20 10 30 20 30 20 10 TT 0 7698 7788 7698 7566 7782

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!

A storeroom is used to organize items stored in it on N shelves. Shelves are numbered from 0 to N-1. The K-th shelf is dedicated to items of only one type, denoted by a positive integer A[K]....

write the OUTPUT below each query. Create an SOL STATEMENT for each query and write it on the right. Test your SQL statements and save your results. OUTPUT 1. Name and salary of all clerks. OUTPUT:...

Write a query to get the maximum salary employee. Write a query to get the average salary of Clerk Write a query to get the average salary of department number 30 Write a query to get the minimum...

Please answer the following queries based on the emp table. SQL> select * from emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 300 500 1400 7369 SMITH 7499 ALLEN 7521 WARD 7566 JONES 7654 MARTIN...

urgently solution required A) Explainthe following terminologies and statements in your own words which are as follows: i. Class.forName("com.mysql.jdbc.Driver"); Connection conn =...

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...

Using the database(SQL), write the queries for all the following questions. More information is provided at the end. From the Emp table, write a query to find those employees whose commission is more...

First: Which of the following outputs would be produced when this SELECT is executed? Explain. (Note: data shown below in question #2!) SQL SELECI donor.idno, name, yrgoal, donation.driveno, contamt,...

1. Create a PL/SQL program block that determines the top students with respect to GPA . Assume that the database has four tables. Student(SSN, SName, DOB, Major) , Grade(SSN, CNo, Grade(0,1,2,3,4))...

1. Create a PL/SQL program block that determines the top students with respect to GPA. Assume that the database has four tables. Student(SSN, SName, DOB, Major) , Grade(SSN, CNo, Grade(0,1,2,3,4))...

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...

What are the major factors that influence customer expectations for adequate service?

Assume Thompson Company, a copy center, lost some inventory in a fire. To file an insurance claim, Thompson Company must estimate its inventory by the gross profit method. Assume that for the past...

Section D: Conclusion ( 3 marks ) Please explain why you, as a future accountant or internal auditor, should care about your employer's ethical policies and their environmental impact. ( 2 ) What can...

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...