Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question
100%

Instructions:

Write the suitable SQL statement to answer the following questions based on the following tables ( image for better table)

Table Name: Employee
 EMP_ID             FNAME               LNAME               SALARY         JOIN_DATE              DEP_NO                     
101                  John                  Abraham            10000                   01-JAN-13          11             
202                  Michael                 Clarke                80000                  01-JAN-13          22            
303                       Roy                   Thomas              70000                  01-FEB-13          11             
404                     Tom                       Jose                  60000                   01-FEB-13          22             
505                        Jerry                    Pinto                 65000                   01-FEB-13               22             
606                    Philip                  Mathew              75000                  01-JAN-13          33                 
707                             Thomas              Jack           65000                  01-JAN-13          33

Table Name: Reward
 EMP_ID             REWARD_DATE               AMOUNT
    101                       01-FEB-13                       5000
     202                     01-FEB-13                        3000
303                          01-FEB-13                        4000
101                          01-JAN-13                        4500
202                          01-JAN-13                        3500

Table Name: Department
DEP_NO             DEP_NAME
 11                        Banking
22                         Insurance
33                         Services
44                        Marketing

 


the question is:

5. Retrieve number of Employee under each Department.   

+Table Name: Employee
EMP ID
FNAME
101
John
202
Michael
303
Roy
404
Tom
505
606
707
Jerry
Philip
Thomas
LNAME SALARY
Abraham
Clarke
Thomas
Jose
Pinto
Mathew
Jack
Table Name: Reward
EMP ID REWARD DATE
101
01-FEB-13
20
01-FEB-13
303
01-FEB-13
101
01-JAN-13
202
01-JAN-13
10000
80000
70000
60000
65000
75000
65000
AMOUNT
5000
3000
4000
4500
3500
JOIN DATE
01-JAN-13
01-JAN-13
01-FEB-13
01-FEB-13
01-FEB-13
01-JAN-13
01-JAN-13
DEP NO
11
22
11
22
22
33
33
Table Name: Department
DEP NO DEP NAME
11
22
33
44
Banking
Insurance
Services
Marketing
expand button
Transcribed Image Text:+Table Name: Employee EMP ID FNAME 101 John 202 Michael 303 Roy 404 Tom 505 606 707 Jerry Philip Thomas LNAME SALARY Abraham Clarke Thomas Jose Pinto Mathew Jack Table Name: Reward EMP ID REWARD DATE 101 01-FEB-13 20 01-FEB-13 303 01-FEB-13 101 01-JAN-13 202 01-JAN-13 10000 80000 70000 60000 65000 75000 65000 AMOUNT 5000 3000 4000 4500 3500 JOIN DATE 01-JAN-13 01-JAN-13 01-FEB-13 01-FEB-13 01-FEB-13 01-JAN-13 01-JAN-13 DEP NO 11 22 11 22 22 33 33 Table Name: Department DEP NO DEP NAME 11 22 33 44 Banking Insurance Services Marketing
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education