Answered: Find the number of staff 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

See similar textbooks

Related questions

Concept explainers

Question

Find the number of staff for each city.

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

Transcribed Image Text:[MariaDB [dreamhome]> Select * from Staff; | staffNo | fName | 1Name | position | sex | SA9 Mary Howe David Ford Assistant | F Supervisor Assistant Ann Beech Susan Brand John White Julie | Lee 6 rows in set (0.001 sec) [MariaDB [dreamhome]> Select * from Branch; | city SG14 SG37 SG5 SL21 SL41 +- | branchNo | street B002 B003 B004 B005 B007 Manager Manager Assistant 56 Cover Drive 163 Main Street 32 Manse Road 22 Deer Road | 16 Argyll Street 5 rows in set (0.001 sec) | | M London Glasgow Bristol London | F | F | M F | DOB salary | 1970-02-19 | 9500.00 1958-03-24 | 1960-11-10 | 12000.00 | 18000.00 1940-06-03 | 24000.00 | postcode | NW10 6EU | G11 9QX BS99 1NZ SW1 4EH Aberdeen | AB2 3SU B003 | 1945-10-01 | 30000.00 B005 1965-06-13 9000.00 B005 | branchNo | + B007 B003 B003 +

Expert Solution

Step by step

Solved in 4 steps with 1 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