1.write one SQL statement to show the positions and the number of staff at each position. 2.write one SQL statement to s
Posted: Sat May 14, 2022 8:08 pm
1.write one SQL statement to show the positions and the number of staff at each position.
2.write one SQL statement to show the DOBs of the managers who work at London.
Branch branch No street city postCode BOOS B007 B003 B004 B002 22 Deer Rd London SWI 4EH 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow G11 9QX 32 Manse Rd Bristol BS99 INZ 56 Clover Dr London NW10 6EU Staff staffNo fName IName position sex DOB salary branchNo SL21 SG37 SG14 SA9 SG5 John Ann David Mary Susan Julie White Manager M Beech Assistant F Ford Supervisor M Howe Assistant F Brand Manager F Lee Assistant F Z. 1-Oct-45 30000 3005 10-Nov-60 12000 B003 24-Mar-5818000 B003 19-Feb-70 9000 B007 3-Jun-40 24000 B003 13-Jun-65 9000 B005 SL41
2.write one SQL statement to show the DOBs of the managers who work at London.
- 1 Write One Sql Statement To Show The Positions And The Number Of Staff At Each Position 2 Write One Sql Statement To S 1 (41.89 KiB) Viewed 51 times