Answered: Show the number of staff for each…

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

Related questions

Question

• Show the number of staff for each position.

• Show the number of staff for each gender in each branch.

• Show the number of female staff in each branch.

Transcribed Image Text:The image displays a table containing information about employees, organized into various columns. Below is the transcribed content and a description: **Table Columns:** 1. **staffNo**: Employee's staff number 2. **fName**: Employee's first name 3. **lName**: Employee's last name 4. **position**: Employee's job position 5. **sex**: Employee's gender (M for male, F for female) 6. **DOB**: Employee's date of birth 7. **salary**: Employee's salary 8. **branchNo**: Branch number where the employee works **Table Data:** - **Row 1:** - staffNo: SA9 - fName: Mary - lName: Howe - position: Assistant - sex: F - DOB: 1970-02-19 - salary: 9500.00 - branchNo: B007 - **Row 2:** - staffNo: SG14 - fName: David - lName: Ford - position: Supervisor - sex: M - DOB: 1958-03-24 - salary: 18000.00 - branchNo: B003 - **Row 3:** - staffNo: SG37 - fName: Ann - lName: Beech - position: Assistant - sex: F - DOB: 1960-11-10 - salary: 12000.00 - branchNo: B003 - **Row 4:** - staffNo: SG5 - fName: Susan - lName: Brand - position: Manager - sex: F - DOB: 1940-06-03 - salary: 24000.00 - branchNo: B003 - **Row 5:** - staffNo: SL21 - fName: John - lName: White - position: Manager - sex: M - DOB: 1945-10-01 - salary: 30000.00 - branchNo: B005 - **Row 6:**

Expert Solution

Step 1: Defining Introduction:

The SQL queries for the given questions are provided below.

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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