Given the following Staff2 table, please write a SQL statement to find the superno who supervised 4 or more sta The superno is the supervisor's staffno. staffno fname Iname position sex DOB ABC1 New Engineer Intern Super User M CC1 DBA M SA9 Mary Howe Assistant F SG14 David Ford Supervisor M Assistant F Manager IF Manager M Assistant F Assistant M SG37 Ann Beech SG5 Susan Brand SL21 John White SL41 Julie Lee XY1 New Tester salary branchno superno 9000 B002 SL21 SG14 1/1/2000 1/1/1995 90000 B005 2/19/1970 9000 B007 3/24/1958 18000 B003 11/10/1960 12000 B003 6/3/1940 24000 B003 10/1/1945 30000 B005 6/13/1965 9000 B005 1/1/1990 8000 B002 SG5 SG5 SG5 SL21 NULL SL21 SL21
Given the following Staff2 table, please write a SQL statement to find the superno who supervised 4 or more sta The superno is the supervisor's staffno. staffno fname Iname position sex DOB ABC1 New Engineer Intern Super User M CC1 DBA M SA9 Mary Howe Assistant F SG14 David Ford Supervisor M Assistant F Manager IF Manager M Assistant F Assistant M SG37 Ann Beech SG5 Susan Brand SL21 John White SL41 Julie Lee XY1 New Tester salary branchno superno 9000 B002 SL21 SG14 1/1/2000 1/1/1995 90000 B005 2/19/1970 9000 B007 3/24/1958 18000 B003 11/10/1960 12000 B003 6/3/1940 24000 B003 10/1/1945 30000 B005 6/13/1965 9000 B005 1/1/1990 8000 B002 SG5 SG5 SG5 SL21 NULL SL21 SL21
Chapter12: Subqueries And Merge Statements
Section: Chapter Questions
Problem 19MC
Related questions
Question
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 2 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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr