TABLE:
QUESTION:
Help Save ABC External Data Database Tools Fields Table Tell me what you wa 21 Ascending Selection New Totals Al Descending Advanced Filter Refresh Spelling Find inter 4. Remove Sort Y Toggle Filter All X Delete More Sort & Filter Records Violations X License Plates Platelmages X ViolationID License Platel. Violation Type - DateOfViolat - Click to Add- 1 JHU3276 SPEEDING 4/11/2011 2 DYV4784 ROBBERY 4/11/2011 3 SWT2222 ROBBERY 4/12/2011 4 LCR2649 SPEEDING 4/15/2011 5 LGR8807 SPEEDING 4/19/2011 6 LCN5339 STOPLIGHT 4/24/2011 7 LGR8468 SPEEDING 4/29/2011 8 LCN5339 UNINSURED 5/4/2011 9 LGR8468 SPEEDING 5/7/2011 10 JHU6674 DELINQUENT FI 5/8/2011 11 SWT2222 ROBBERY 5/13/2011 12 LCN5339 ROBBERY 5/16/2011 13 DYV4784 ASSAULT 5/17/2011 14 JHR6200 HIT AND RUN 5/21/2011 15 DYV4784 SPEEDING 5/25/2011 16 LCR2649 UNINSURED 5/27/2011 17 VEK3378 ROBBERY 5/28/2011 18 LCR2649 STOPLIGHT 6/2/2011 19 LIE2394 SPEEDING 6/3/2011 20 JHU6674 SPEEDING 6/5/2011 21 PKL9308 ROBBERY 6/7/2011 22 LIE2394 UNINSURED 6/11/2011 23 JHU6674 STOPLIGHT 6/13/2011 24 LCR2649 ASSAULT 6/18/2011 25 JKR6902 ROBBERY 6/21/2011 Text Formatting - Click to Add- ZEV Violations License Platel - OCDE6727 CDE7704 DKE2390 E DYV4437 E DYV4784 EVK3498 EVK3939 EVK6376 IHR3124 DJHR6200 JHR8041 DIHU3276 HU6674 TO JHU7782 JKR6902 KW1999 JKW7823 UE2018 KE11976 DI KE887 BIKFE 7420 DI KFE8979 LCN5339 El LCR1923 LCR2149 LCR2649 El GR1769 LGR8468 LGR8807 LIE2394 Records License Plates X 3. Platelimages X Make OwnerlastNe - OwnerFirstNi - StreetAddres. Sector CHEVROLET KUSZEWSKI PO BOX 333 EAST END FORD LIBERLES JOHN 1534343 ENADI NORTH BAY VOLKSWAGON SURI ANN 5 LONG ST EAST END FORD HO JACOB 4911 N DOROI SOUTH BY TOYOTA WOLFF KURT 7391 ROCKY RO WEST BAY TOYOTA ROTH BENJAMIN 36411 GRACE TI NORTH BAY HONDA DIENES DANIEL 137 ADELE RD WEST BAY CHEVROLET GORRY BLAINE 11 MCKEAN RD NORTH BAY CHEVROLET JANCA WALTER 15356 EDGEWO EAST END HONDA BAHCALL ESTEBAN 11 TRINITY PL NORTH BAY TOYOTA HSU DANIEL 1719 N LINE ST NORTH BAY HONDA STREET JULIE 3434 SHERWOC SOUTH BAY CHEVROLET ZIRVI STEVE 319 NPLEASAN NORTH BAY VOLKSWAGON CHO TAKAO S SANDSTONE V SOUTH BAY TOYOTA STABLES MICHAEL 97 JACKSON RD EAST END HONDA PASSANANTE JOSHUA 151 E ZENITH AY WEST BAY FORD MORRONE DOUGLAS 15 RICHARDS RI SOUTH BAY HONDA BEHUN ANTOINETTE 9 QUAIL COVE F SOUTH BAY BUICK HUNG JESSICA 79 EAST HIGH S SOUTH BAY VOLKSWAGON SHIAU STEVE 3195 17TH STN SOUTH BAY FORD SMITH GEORGE 17934 NE 334TH WEST BAY CHEVROLET TAITSMAN ANDREW 15 STUYVESANT EAST END BMW BRACY KARI 617 N MAPLE DI SOUTH BAY CHEVROLET ADLER PETER 1717 PRAIRIE A EAST END BMW ARCAL DARIA 13 WITH ST NORTH BAY BMW ARCAL DEVIN 45 W 9TH ST NORTH BAY TOYOTA ABRONS JAMES 915 BELLAIRE A EAST END VOLKSWAGON RYAN HELENE 1355 F WATROL SOUTH BAY FORD AHN SANDRA 3119 HATACAR WEST BAY VOLKSWAGON WEINER JOHN 151 BAINBRIDG SOUTH RAY Color GREY BLACK WHITE BLUE WHITE WHITE TAN GREEN GREEN WHITE GREY WHITE WHITE GREEN BLUE TAN GREY GREY WHITE BLACK GREEN RED RED WHITE GREY RED WHITE GREEN RED BLACK Records E Violations X License Plates Platelmages X ViolationID License Platel - Violation Type - DateOfViolat. Click to Add 1 JHU3276 SPEEDING 4/11/2011 2 DYV4784 ROBBERY 4/11/2011 3 SWT2222 ROBBERY 4/12/2011 4 LCR2649 SPEEDING 4/15/2011 5 LGR8807 SPEEDING 4/19/2011 6 LCN5339 STOPLIGHT 4/24/2011 7 LGR8468 SPEEDING 4/29/2011 8 LCN5339 UNINSURED 5/4/2011 9 LGR8468 SPEEDING 5/7/2011 10 JHU6674 DELINQUENT FI 5/8/2011 11 SWT2222 ROBBERY 5/13/2011 12 LCN5339 ROBBERY 5/16/2011 13 DYV4784 ASSAULT 5/17/2011 14 JHR6200 HIT AND RUN 5/21/2011 15 DYV4784 SPEEDING 5/25/2011 16 LCR2649 UNINSURED 5/27/2011 17 VEK3378 ROBBERY 5/28/2011 18 LCR2649 STOPLIGHT 6/2/2011 19 LIE2394 SPEEDING 6/3/2011 20 JHU6674 SPEEDING 6/5/2011 21 PKL9308 ROBBERY 6/7/2011 22 LIE2394 UNINSURED 6/11/2011 23 JHU6674 STOPLIGHT 6/13/2011 24 LCR2649 ASSAULT 6/18/2011 25 JKR6902 ROBBERY 6/21/2011 4-40. Why is PlateImagesID the primary key for the PlateImages table, rather than License PlateNumber? 4-41. A police officer spots a car illegally parked on a dark street, with license plate LCN5339. Query the database and list any crimes or other violations that are linked to this license plate. 4-42. A citizen reports a robbery to the police, but she can only remember the first three letters of the car's license plate (JKR). She thinks it was a black or dark blue Toyota. Which car is the best candidate, and who is the owner
