Background Branch State zipCode City mg Stats Member branch No street Tortland OR 97201 Eure 2.4 example of the av Home
Posted: Sun May 15, 2022 1:59 pm
- Background Branch State Zipcode City Mg Stats Member Branch No Street Tortland Or 97201 Eure 2 4 Example Of The Av Home 1 (96.01 KiB) Viewed 87 times
following SQL command when the referential actions for all data
sets are one of CASCADE, SET NULL, SET DEFAULT, and NO ACTION for
using on DELETE clause.
DELETE
FROM Video WHERE title =
‘Die Another Day’;
b. Identify each one of the following SQL
commands as legal or illegal. If the command is legal,
show its execution result. Otherwise, explain why the
command is illegal.
(1) SELECT v.*,
character FROM Video v, Actor a, Role
r WHERE actorNo =
‘A7525’ AND a.actorNo =
r.actorNo AND r.catalogNo =
v.catalogNo;
(2) SELECT branchNo,
staffNo, COUNT(staffNo) AS totalStaff,
SUM(salary)
AS totalSalary FROM Staff GROUP
BY branchNo, staffNo
HAVING COUNT(staffNo)
> 1 ORDER BY branchNo;
(3) SELECT DISTINCT title,
category, directorName
FROM Video v, Director
d WHERE v.directorNo = d.directorNo;
Background Branch State zipCode City mg Stats Member branch No street Tortland OR 97201 Eure 2.4 example of the av Home video antal database. S1500 Name IName address membe No M250178 3001 8 Jefferson Way WA Seattle 98122 S0010 Bob Adams B002 City Center Plaza NY 10012 M166884 Art 50415 Peters B003 14- Sth Avenue 57 - 11th Avenge, Seattle, WA 98105 89 Redmond Rd. Portland, Oll 97117 22 W. Capital Way, Portland, OR 97201 123 Suffolk lane, Seattle, WA 98117 New York Seattle WA 98128 M115656 Serena Parker S2250 B004 16 - 14th Avenue M284354 Dan Nelson Start salary stat No position branchNo name Registration B0X1 46000 Manager S1500 Tom Daniels tranch No memberNo staffNo 30000 Assistant B001 SE3 B002 M250178 S3250 Sally Adams Mary Martinez 50000 B002 S0010 BOO1 M166884 S0003 dateJoined 1-Jul-01 4-Sep-02 12-May- 9-Oct-01 Manager Supervisor Manager 53250 B002 Robert Chin 32000 BXX1 M115656 S0003 S2250 Sally Stern 48000 B004 BOO M284354 S3250 S0415 Art Peters Manager 41000 B003 Video Rental Agreement rentalno dittcut R753161 -Feb-03 date Return member No VideoNo calegory dailyRental price director No 6-Feb-03 M284354 245456 Action 5.00 21.99 11001 R753462 4-Feb-03 6-Feb-03 M284354 243431 catalogNo title 207132 Die Another Day 902355 Harry Potter 330553 Lord of the Rings 781132 Shrek Children 4.50 14.50 D7834 R668256 5-Feb-03 7-Feb-03 M315656 199004 Fantasy 5.00) 31.99 14576 R668189 2 Feb-03 M115656 178643 Children 4.00 18.50 D(078 +45624 Action 4.00 29.99 Men in Black II Independence Day D5743 VideoForRent 634817 Sci-Fi 4.50 32.99 D3765 Video No available catalogNo branch No 199004 Y 207132 B001 Role Director Actor 24.5456 207132 BODA directo No directotume actorNo catalogNo character actorNo actor Name 178643 N 634817 BOOL D1001 A1002 207132 Lee Tamahori A1002 243431 Y BOXO2 634817 Pierce Brosnan D7834 A3006 Chris Columbus 330553 James Bond Frodo Baggins Harry Potter A3006 Elijah Wood D4576 Peter Jackson A3006 902355 A2019 Will Smith DO078 Andrew Adamson A2019 634817 A3525 Tommy Lee Jones Captain Steve Hier 05743 A2019 A4343 145624 Barry Sonnenfeld Roland Emmenck Mike Myers Agent D3765 A8401 A7525 Daniel Radcliffe 445624 Agent Shrek A4343 781132