a03b2Interest.accdb
| AccountID | CustomerID | BranchID | Balance | OpenDate |
| 1001 | 30010 | B50 | ¤ 5,600.00 | 5/1/95 |
| 1002 | 30001 | B10 | ¤ 1,200.00 | 4/14/03 |
| 1003 | 30004 | B20 | ¤ 15,490.00 | 5/29/02 |
| 1004 | 30003 | B30 | ¤ 630.00 | 9/21/01 |
| 1005 | 30009 | B50 | ¤ 1,300.00 | 7/23/03 |
| 1006 | 30003 | B10 | ¤ 550.00 | 7/3/01 |
| 1007 | 30007 | B20 | ¤ 1,620.00 | 6/7/04 |
| 1008 | 30004 | B40 | ¤ 2,100.00 | 9/30/05 |
| 1009 | 30005 | B50 | ¤ 1,500.00 | 2/8/04 |
| 1010 | 30001 | B20 | ¤ 3,000.00 | 3/18/08 |
| 1011 | 30005 | B10 | ¤ 290.00 | 10/16/00 |
| 1012 | 30002 | B30 | ¤ 1,900.00 | 3/14/05 |
| 1013 | 30001 | B20 | ¤ 10,000.00 | 5/18/97 |
| 1014 | 30009 | B10 | ¤ 16,700.00 | 9/20/95 |
| 1015 | 30004 | B30 | ¤ 460.00 | 4/4/01 |
| 1016 | 30001 | B30 | ¤ 18,700.00 | 3/13/01 |
| 1017 | 30010 | B30 | ¤ 980.00 | 9/6/02 |
| 1018 | 30005 | B40 | ¤ 7,800.00 | 5/9/91 |
| 1019 | 30004 | B30 | ¤ 14,250.00 | 1/5/99 |
| 1020 | 30001 | B50 | ¤ 12,000.00 | 4/14/03 |
| 1021 | 30011 | B50 | ¤ 21,004.00 | 7/3/07 |
| 1022 | 30003 | B50 | ¤ 4,000.00 | 4/13/09 |
| 1023 | 30011 | B50 | ¤ 1,000.00 | 1/1/09 |
| BranchID | Manager | Location | StartDate |
| B10 | Mast | Uptown | 12/1/04 |
| B20 | Esposito | Eastern | 6/17/05 |
| B30 | Amoako | Western | 3/11/03 |
| B40 | Singh | Southern | 9/15/06 |
| B50 | YourLastName | Campus | 10/11/08 |
| CustomerID | FirstName | LastName | Street | City | State | Zip | Phone |
| 30001 | Allison | Millward | 2732 Baker Blvd. | Greensboro | NC | 27492 | 3363345678 |
| 30002 | Bernett | Fox | 12 Orchestra Terrace | High Point | NC | 27494 | 3363583364 |
| 30003 | Andrew | Hayes | P.O. Box 555 | Greensboro | NC | 27492 | 3369984457 |
| 30004 | Cordle | Collins | 2743 Bering St. | Winston-Salem | NC | 27492 | 3364472283 |
| 30005 | Eaton | Wagner | 2743 Bering St. | Greensboro | NC | 27492 | 3369883346 |
| 30006 | Kwasi | Williams | 89 Jefferson Way | High Point | NC | 27494 | 3364475565 |
| 30007 | Natasha | Simpson | 187 Suffolk Ln. | Greensboro | NC | 27493 | 3367753389 |
| 30008 | Joy | Jones | 305 - 14th Ave. S. | Winston-Salem | NC | 27493 | 3362587655 |
| 30009 | John | Nunn | 89 Chiaroscuro Rd. | Greensboro | NC | 27494 | 3349985557 |
| 30010 | Laura | Peterson | 120 Hanover Sq. | Winston-Salem | NC | 27492 | 3363346654 |
| 30011 | YourName | YourName | 124 N. Main St | Alamance | NC | 27201 | 3365550000 |
SELECT Customers.LastName, Accounts.Balance, Branch.Location, [Balance]*0.035/12 AS MonthlyInterest
FROM Customers INNER JOIN (Branch INNER JOIN Accounts ON Branch.BranchID = Accounts.BranchID) ON Customers.CustomerID = Accounts.CustomerID;
Mo7ammedaziz 
