Answered: Find the staff name who has the maximum…

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

Concept explainers

Question

Find the staff name who has the maximum salary for each city.

Transcribed Image Text:### MariaDB Data Transcription #### Table 1: Staff The "Staff" table contains the following columns: - **staffNo**: Staff number - **fName**: First name - **lName**: Last name - **position**: Job position - **sex**: Gender - **DOB**: Date of birth - **salary**: Salary - **branchNo**: Branch number The records in the Staff table are: 1. **SA9**: Mary Howe, Assistant, Female, DOB: 1970-02-19, Salary: 9500.00, Branch: B007 2. **SG14**: David Ford, Supervisor, Male, DOB: 1958-03-24, Salary: 18000.00, Branch: B003 3. **SG37**: Ann Beech, Assistant, Female, DOB: 1960-11-10, Salary: 12000.00, Branch: B003 4. **SG5**: Susan Brand, Manager, Female, DOB: 1940-06-03, Salary: 24000.00, Branch: B003 5. **SL21**: John White, Manager, Male, DOB: 1945-10-01, Salary: 30000.00, Branch: B005 6. **SL41**: Julie Lee, Assistant, Female, DOB: 1965-06-13, Salary: 9000.00, Branch: B005 **Summary**: 6 rows in set (0.001 sec). #### Table 2: Branch The "Branch" table features these columns: - **branchNo**: Branch number - **street**: Street address - **city**: City - **postcode**: Postal code The records in the Branch table are: 1. **B002**: 56 Cover Drive, London, NW10 6EU 2. **B003**: 163 Main Street, Glasgow, G11 9QX 3. **B004**: 32 Manse Road, Bristol, BS99 1NZ 4. **B005**: 22 Deer Road, London, SW1 4EH 5. **B007**: 16 Argyll Street, Aberdeen, AB2 3SU **Summary**

Expert Solution

Step by step

Solved in 3 steps

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