Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
1- From the following tables write a SQL query to find the names of departments where more than two employees are employed. Return dpt_name?

1- From the following tables write a SQL query to find the names of departments where more than two employees are employed. Return dpt_name?

Database System Concepts
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
See similar textbooks
icon
Related questions
Question

ussing oracle 

**Using Oracle Language to Solve SQL Queries** The following set of tables and query form the basis for an educational exercise in SQL using Oracle. The task is to write a SQL query to find department names where more than two employees are employed. ### Table: emp_department - **Columns:** - `DPT_CODE`: Department Code - `DPT_NAME`: Department Name - `DPT_ALLOTMENT`: Department Allotment | DPT_CODE | DPT_NAME | DPT_ALLOTMENT | |----------|-----------|---------------| | 57 | IT | 65000 | | 63 | Finance | 15000 | | 47 | HR | 240000 | | 27 | RD | 55000 | | 89 | QC | 75000 | ### Table: emp_details - **Columns:** - `EMP_IDNO`: Employee ID Number - `EMP_FNAME`: Employee First Name - `EMP_LNAME`: Employee Last Name - `EMP_DEPT`: Employee Department Code | EMP_IDNO | EMP_FNAME | EMP_LNAME | EMP_DEPT | |----------|-----------|-----------|----------| | 127323 | Michale | Robbin | 57 | | 526689 | Carlos | Snares | 63 | | 843795 | Enric | Dosio | 57 | | 328717 | Jhon | Snares | 63 | | 444527 | Joseph | Dosni | 47 | | 659831 | Zanifer | Emily | 47 | | 847674 | Kuleswar | Sitaraman | 57 | | 748681 | Henrey | Gabriel | 47 | | 555935 | Alex | Manuel | 57 | | 539569 | George | Mardy | 27 | | 733843 | Mario | Saule | 63 | | 631548 | Alan | Snappy | 27 | | 839139 | Maria | Foster | 57 | ### Table: company_mast - **Columns:**
Transcribed Image Text:**Using Oracle Language to Solve SQL Queries** The following set of tables and query form the basis for an educational exercise in SQL using Oracle. The task is to write a SQL query to find department names where more than two employees are employed. ### Table: emp_department - **Columns:** - `DPT_CODE`: Department Code - `DPT_NAME`: Department Name - `DPT_ALLOTMENT`: Department Allotment | DPT_CODE | DPT_NAME | DPT_ALLOTMENT | |----------|-----------|---------------| | 57 | IT | 65000 | | 63 | Finance | 15000 | | 47 | HR | 240000 | | 27 | RD | 55000 | | 89 | QC | 75000 | ### Table: emp_details - **Columns:** - `EMP_IDNO`: Employee ID Number - `EMP_FNAME`: Employee First Name - `EMP_LNAME`: Employee Last Name - `EMP_DEPT`: Employee Department Code | EMP_IDNO | EMP_FNAME | EMP_LNAME | EMP_DEPT | |----------|-----------|-----------|----------| | 127323 | Michale | Robbin | 57 | | 526689 | Carlos | Snares | 63 | | 843795 | Enric | Dosio | 57 | | 328717 | Jhon | Snares | 63 | | 444527 | Joseph | Dosni | 47 | | 659831 | Zanifer | Emily | 47 | | 847674 | Kuleswar | Sitaraman | 57 | | 748681 | Henrey | Gabriel | 47 | | 555935 | Alex | Manuel | 57 | | 539569 | George | Mardy | 27 | | 733843 | Mario | Saule | 63 | | 631548 | Alan | Snappy | 27 | | 839139 | Maria | Foster | 57 | ### Table: company_mast - **Columns:**
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Multiple table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS