Find the staff name who has the maximum salary for each city.
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
Related questions
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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps

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.Recommended textbooks for you

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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education