| CenterName | CenterStreet | CenterCity | CenterState | CenterZip | CenterPhone | ContactFirst | ContactLast | CenterNumber | Hazardous |
| A1 Salvage Center | 987 Main Street | Stillwell | KS | 61111 | 5551236666 | Rhea | Knox | 1 | true |
| Johnson Recycling | 12345 Antioch Boulevard | Bridgewater | KS | 63444 | 5552227897 | Derek | Pence | 2 | true |
| Adair county Recycling | 12444 Cordoba Drive | Adair | KS | 64222 | 5557809999 | Andrea | Russo | 3 | false |
| Taney County Salvage | 78900 Carthage Street | Greenfield | KS | 65444 | 5551111234 | Gina | Pitt | 4 | false |
| ClubNumber | ClubName | ClubStreet | ClubCity | ClubState | ClubZip | ClubPhone | FName | LName |
| 1 | Kansas City Frogman Club | 111 Elm Street | Overland Park | KS | 66213 | 5551238888 | Jordan | Smith |
| 2 | Boy Scout Troop 324 | 22 West 67th Drive | Mission | KS | 60603 | 5551117777 | Charles | Schaffer |
| 3 | Great Plains 4-H | 44 East 99th Road | Lenexa | KS | 66111 | 5552222222 | Renaldo | Bartles |
| 4 | JavaScript KC | 777 Oxford Street | Fontanelle | KS | 66333 | 5553333111 | Cory | Harding |
| 5 | Junior League | 3333 Princeton Lane | Point Lookout | MO | 55886 | 7772134333 | Amy | Moon |
| 6 | Access Users Group | 55 Oak Drive | Ridgedale | MO | 55887 | 7771224444 | Trey | Hickman |
| 7 | Social Media Club | 888 Switzer Street | Kansas City | MO | 55888 | 7772223333 | Trixie | Cho |
| 8 | Alpha Alpha Alpha | 1414 Sunset Drive | Ames | IA | 50010 | 5557778888 | Student First | Student last |
| DepositID | DepositDate | Weight | CenterNumber | ClubNumber |
| 1 | 1/30/14 | 60.0 | 4 | 1 |
| 2 | 1/30/14 | 100.0 | 4 | 1 |
| 3 | 2/4/14 | 75.0 | 2 | 4 |
| 4 | 2/4/14 | 80.0 | 1 | 4 |
| 5 | 2/8/14 | 150.0 | 2 | 5 |
| 6 | 2/13/14 | 200.0 | 2 | 6 |
| 7 | 2/14/14 | 50.0 | 2 | 1 |
| 8 | 2/16/14 | 50.0 | 1 | 7 |
| 9 | 2/17/14 | 40.0 | 3 | 1 |
| 10 | 2/18/14 | 100.0 | 4 | 7 |
| 11 | 2/20/14 | 200.0 | 4 | 2 |
| 12 | 2/22/14 | 75.0 | 4 | 6 |
| 13 | 2/23/14 | 80.0 | 1 | 4 |
| 14 | 2/26/14 | 100.0 | 4 | 6 |
| 15 | 3/1/14 | 150.0 | 2 | 5 |
| 16 | 3/2/14 | 70.0 | 4 | 4 |
| 17 | 3/3/14 | 100.0 | 3 | 7 |
| 18 | 3/4/14 | 150.0 | 3 | 5 |
| 19 | 3/5/14 | 200.0 | 4 | 1 |
| 20 | 3/6/14 | 50.0 | 2 | 6 |
| 21 | 1/30/15 | 60.0 | 1 | 1 |
| 22 | 1/30/15 | 100.0 | 2 | 6 |
| 23 | 2/4/15 | 80.0 | 1 | 4 |
| 24 | 2/4/15 | 75.0 | 4 | 4 |
| 25 | 2/8/15 | 150.0 | 2 | 5 |
| 26 | 2/13/15 | 185.0 | 2 | 6 |
| 27 | 2/14/15 | 50.0 | 4 | 1 |
| 28 | 2/16/15 | 35.0 | 1 | 7 |
| 29 | 2/17/15 | 40.0 | 3 | 1 |
| 30 | 2/18/15 | 185.0 | 4 | 6 |
| 31 | 2/20/15 | 200.0 | 3 | 2 |
| 32 | 2/22/15 | 75.0 | 4 | 5 |
| 33 | 2/23/15 | 80.0 | 1 | 4 |
| 34 | 2/26/15 | 65.0 | 2 | 4 |
| 35 | 3/2/15 | 150.0 | 1 | 5 |
| 36 | 3/3/15 | 50.0 | 3 | 4 |
| 37 | 3/4/15 | 45.0 | 3 | 7 |
| 38 | 3/5/15 | 75.0 | 4 | 5 |
| 39 | 3/6/15 | 200.0 | 1 | 1 |
| 40 | 3/7/15 | 145.0 | 4 | 6 |
| 41 | 4/19/15 | 115.0 | 4 | 6 |
| 42 | 4/20/15 | 65.0 | 4 | 1 |
| 43 | 4/22/15 | 105.0 | 2 | 1 |
| 44 | 4/23/15 | 90.0 | 4 | 2 |
| 45 | 4/25/15 | 65.0 | 1 | 1 |
| 46 | 4/30/15 | 205.0 | 3 | 2 |
| 47 | 5/1/15 | 105.0 | 4 | 6 |
| 48 | 5/7/15 | 190.0 | 3 | 2 |
| 49 | 6/4/15 | 90.0 | 4 | 4 |
| 50 | 6/7/15 | 65.0 | 3 | 4 |
| 51 | 6/19/15 | 65.0 | 1 | 4 |
| 52 | 6/20/15 | 85.0 | 4 | 5 |
| 53 | 6/22/15 | 95.0 | 3 | 1 |
| 54 | 7/7/15 | 75.0 | 3 | 5 |
| 55 | 7/8/15 | 200.0 | 2 | 1 |
| 56 | 8/31/15 | 50.0 | 4 | 6 |
| 57 | 9/24/15 | 200.0 | 2 | 5 |
| 58 | 10/1/15 | 90.0 | 3 | 5 |
| 59 | 10/2/15 | 90.0 | 4 | 4 |
| 60 | 10/4/15 | 80.0 | 2 | 5 |
| 61 | 1/4/16 | 60.0 | 1 | 2 |
| 62 | 1/6/16 | 90.0 | 2 | 7 |
| 63 | 2/14/16 | 50.0 | 3 | 7 |
| 64 | 2/18/16 | 30.0 | 2 | 2 |
| 65 | 2/21/16 | 50.0 | 4 | 6 |
| 66 | 2/22/16 | 100.0 | 3 | 6 |
| 67 | 2/28/16 | 125.0 | 2 | 4 |
| 68 | 3/15/16 | 60.0 | 1 | 2 |
| 69 | 4/3/16 | 115.0 | 1 | 4 |
| 70 | 4/18/16 | 105.0 | 1 | 2 |
| 71 | 5/18/16 | 90.0 | 2 | 2 |
| 72 | 5/19/16 | 80.0 | 3 | 1 |
| 73 | 5/20/16 | 50.0 | 4 | 1 |
| 74 | 5/31/16 | 60.0 | 4 | 6 |
| 75 | 6/1/16 | 65.0 | 3 | 4 |
| 76 | 6/7/16 | 75.0 | 3 | 5 |
| 77 | 6/8/16 | 95.0 | 2 | 2 |
| 78 | 6/9/16 | 90.0 | 2 | 1 |
| 79 | 7/10/16 | 85.0 | 1 | 2 |
| 80 | 7/11/16 | 95.0 | 1 | 4 |
| 81 | 7/16/16 | 65.0 | 4 | 6 |
| 82 | 7/17/16 | 85.0 | 3 | 4 |
| 83 | 7/19/16 | 45.0 | 2 | 5 |
| 84 | 8/19/16 | 205.0 | 1 | 7 |
| 85 | 8/20/16 | 105.0 | 2 | 1 |
| 86 | 9/18/16 | 30.0 | 3 | 2 |
| 87 | 10/19/16 | 60.0 | 4 | 4 |
| 88 | 10/20/16 | 40.0 | 3 | 4 |
| 89 | 10/30/16 | 90.0 | 2 | 4 |
| 90 | 10/31/16 | 80.0 | 1 | 1 |
| 91 | 11/1/16 | 25.0 | 2 | 4 |
| 92 | 11/2/16 | 100.0 | 4 | 2 |
| 93 | 11/16/16 | 85.0 | 4 | 5 |
| 94 | 11/17/16 | 75.0 | 3 | 5 |
| 95 | 11/18/16 | 85.0 | 3 | 6 |
| 96 | 11/29/16 | 90.0 | 3 | 5 |
| 97 | 12/1/16 | 80.0 | 2 | 6 |
| 98 | 12/3/16 | 70.0 | 2 | 7 |
| 99 | 12/6/16 | 80.0 | 1 | 7 |
| 100 | 12/8/16 | 50.0 | 4 | 6 |
| 101 | 1/2/17 | 45.0 | 2 | 5 |
| 102 | 1/3/17 | 205.0 | 1 | 7 |
| 103 | 1/7/17 | 105.0 | 2 | 1 |
| 104 | 1/7/17 | 30.0 | 3 | 2 |
| 105 | 1/7/17 | 60.0 | 4 | 3 |
| 106 | 1/8/17 | 140.0 | 3 | 5 |
| 107 | 1/9/17 | 90.0 | 4 | 7 |
| 108 | 1/9/17 | 80.0 | 3 | 1 |
| 109 | 1/13/17 | 125.0 | 4 | 2 |
| 110 | 1/13/17 | 100.0 | 1 | 4 |
| 111 | 1/14/17 | 85.0 | 4 | 5 |
| 112 | 1/15/17 | 175.0 | 1 | 7 |
| 113 | 1/16/17 | 85.0 | 4 | 6 |
| 114 | 1/20/17 | 190.0 | 1 | 5 |
| 115 | 1/20/17 | 80.0 | 2 | 4 |
| 116 | 1/21/17 | 170.0 | 3 | 3 |
| 117 | 1/21/17 | 80.0 | 2 | 1 |
| 118 | 1/21/17 | 150.0 | 4 | 2 |
SELECT Centers.CenterName, Deposits.DepositDate, Deposits.Weight, Clubs.ClubName
FROM Clubs INNER JOIN (Centers INNER JOIN Deposits ON Centers.CenterNumber = Deposits.CenterNumber) ON Clubs.ClubNumber = Deposits.ClubNumber;