Microsoft Access

profilemaladam
1-WEDistributors1.accdb
Home>Computer Science homework help>Microsoft Access
MovieID MovieTitle Rating Length ReleaseDate Genre MovieStudio DirectorLastName DirectorFirstName
1 Ring of Roses G 129 2/10/14 Adventure Marquee Productions Fontana Alphonse
2 The Codebreakers of World War II G 183 12/30/15 History Marquee Productions Boskovic Elena
3 The Life of Winston Churchill G 125 1/15/16 Biography Marquee Productions Tanner Leslie
4 Two by Two G 95 3/15/17 Action Marquee Productions Passmore Jayson
5 Going Global G 164 9/1/18 Documentary Marquee Productions Patel Rashi
OrderID DistID MovieStartDate MovieEndDate MovieID Fee
1 4 3/10/18 4/29/18 3 ¤ 15,000.00
2 3 3/15/18 4/1/18 1 ¤ 20,000.00
3 11 3/15/18 4/20/18 2 ¤ 18,000.00
4 5 3/15/18 4/15/18 4 ¤ 45,000.00
5 8 3/20/18 4/30/18 3 ¤ 15,000.00
6 13 3/20/18 4/25/18 2 ¤ 12,000.00
7 7 3/21/18 4/15/18 4 ¤ 45,000.00
8 6 3/22/18 4/10/18 1 ¤ 20,000.00
9 2 3/23/18 5/1/18 1 ¤ 18,000.00
10 14 3/25/18 4/25/18 3 ¤ 15,000.00
11 15 3/26/18 5/1/18 4 ¤ 45,000.00
12 1 3/27/18 4/30/18 2 ¤ 18,000.00
13 10 3/28/18 4/28/18 1 ¤ 20,000.00
14 19 3/29/18 5/10/18 3 ¤ 12,000.00
15 16 3/30/18 5/10/18 3 ¤ 15,000.00
DistID CompanyName StreetAdd1 StreetAdd2 City State ZIPCode Telephone Fax EmailAdd
1 All Nite Cinemas 2188 Third Street Louisville KY 40201 502-555-4238 502-555-4240 [email protected]
2 Century Cinemas 3687 Avenue K Arlington TX 76013 817-555-2116 817-555-2119 [email protected]
3 Countryside Cinemas 22 Hillside Street Bennington VT 05201 802-555-1469 802-555-1470 [email protected]
4 Danforth Cinemas PO Box 22 18 Pickens Street Columbia SC 29201 803-555-3487 803-555-3421 [email protected]
5 Eastown Movie House PO Box 722 1 Concourse Avenue Cambridge MA 02142 413-555-0981 413-555-0226 [email protected]
6 Hillman Cinemas 55 Kemble Avenue Baking Ridge NJ 07920 201-555-1147 201-555-1143 [email protected]
7 LaVista Cinemas 111 Vista Road Phoenix AZ 86355-6014 602-555-6231 602-555-6233 [email protected]
8 Liberty Cinemas PO Box 998 12011 Ruston Way Atlanta GA 73125 404-555-8113 404-555-2349 [email protected]
9 Mainstream Movies PO Box 33 333 Evergreen Building Seattle WA 98220-2791 206-555-3269 206-555-3270 [email protected]
10 Marquee Movies 1011 South Alameda Street Los Angeles CA 90045 612-555-2398 612-555-2377 [email protected]
11 Midtown Moviehouse 1033 Commercial Street Emporia KS 66801 316-555-7013 316-555-7022 [email protected]
12 Mooretown Movies PO Box 11 331 Metro Place Dublin OH 43107 614-555-8134 614-555-8339 [email protected]
13 O'Shea Movies 59 Erie Oak Park IL 60302 312-555-7719 312-555-7381 [email protected]
14 Redwood Cinemas PO Box 112F 336 Ninth Street Portland OR 97466-3359 503-555-8641 503-555-8633 [email protected]
15 Sunfest Cinemas 341 South Fourth Avenue Tampa FL 33562 813-555-3185 813-555-3177 [email protected]
16 Victory Cinemas 12119 South 23rd San Diego CA 97432-1567 619-555-8746 619-555-8748 [email protected]
17 Waterfront Cinemas PO Box 3255 Buffalo NY 14288 716-555-3845 716-555-3947 [email protected]
18 Wellington 10 1203 Tenth Southwest Philadelphia PA 19178 215-555-9045 215-555-9048 [email protected]
19 Westview Movies 1112 Broadway Newark NY 10119 212-555-4875 212-555-4877 [email protected]
SELECT [Movies].[MovieID], [Movies].[MovieTitle] FROM Movies ORDER BY [MovieTitle];
SELECT DISTINCTROW * FROM Movies;
SELECT DISTINCTROW * FROM Orders;
SELECT DISTINCTROW * FROM US_Distributors;
SELECT DISTINCTROW * FROM Movies;
SELECT DISTINCTROW * FROM US_Distributors;
SELECT Orders.OrderID, US_Distributors.City, US_Distributors.CompanyName, Orders.MovieID, Orders.MovieStartDate, Orders.MovieEndDate FROM US_Distributors INNER JOIN (Movies INNER JOIN Orders ON Movies.MovieID=Orders.MovieID) ON US_Distributors.DistID=Orders.DistID ORDER BY US_Distributors.City;
SELECT Movies.MovieTitle, Orders.OrderID, Orders.MovieStartDate, Orders.MovieEndDate, US_Distributors.CompanyName, US_Distributors.City FROM US_Distributors INNER JOIN (Movies INNER JOIN Orders ON Movies.MovieID=Orders.MovieID) ON US_Distributors.DistID=Orders.DistID ORDER BY Movies.MovieTitle;