MIs433- Module 4: Queries & SQL In this assignment, you are given a complete database file (located in the assignment following this page) which sets the s

MIs433- Module 4: Queries & SQL In this assignment, you are given a complete database file (located in the assignment following this page) which sets the stage for the following list of queries. After you create and test your query, then save it under the name given as a part of the instructions for each query. Note that the file referenced below is located in the assignment submission folder that immediately follows this page.

Download the Module4.accdb database. (Located in the assignment submission folder located after this page.)
Get to know the tables.
Review the Relationship across all the tables. This will help you when you work on a multi-table query.
Create a query to list all the data from the Customers table ordered in the ascending order of the State field. Save the query as Q1
Create a query to list the Company name, address and balance of the customers who have a balance over $0. Save it as Q2.
Create a query to list the names of the customers who purchase a GMC Pickup (ID 59) or Ford Convertible (ID 15). This is a multi-table type of query. Save it as Q3.
Create a parameter query of your choice. Use any table and criteria you choose. Save it as Q4.
Create a multi-table query of your choice using an ‘AND’ operator. Save it as Q5. CustomerID Company Address City State ZipCode Phone Fax Email WebSite InitialCustomerDate CreditLimit CurrentBalance CreditStatus LastSalesDate DiscountPercent Active

1 Fun Zone 105 S Dubuque Street Iowa City IA 52240 (319) 352-0725 (860) 555-1930 sales@@funzone.com www.funzone.com 11/7/07 ¤ 8,000.00 ¤ 1,259.00 OK 0.35 true

2 Exelon Shoppe 123 South Street Newington NH 12301 (603) 555-6887 (603) 555-6880 sales@ExelonShoppe.com www.ExelonShoppe.com 12/31/03 ¤ 1,800.00 ¤ 0.00 OK 0.4 true

3 Southwest Softies Rt 9 Pine Plains NY 12567 (518) 555-6699 (518) 555-6690 schina@SouthwestSofties.com www.SouthwestSofties.com 12/31/13 ¤ 1,800.00 ¤ 650.00 OK 0.3 true

4 Pinnacle Playables 560 Broadway Salem NH 03079 (603) 555-4422 (603) 555-4420 sampsg@PinnaclePlayables.com www.PinnaclePlayables.com 12/31/09 ¤ 800.00 ¤ 156.00 OK 0.35 true

5 Toys in the Basement 100 Elm Street Sunnyville GA 12305 (478) 555-8822 (478) 555-8822 james@ToysInTheBasement.com www.ToysInTheBasement.com 12/31/11 ¤ 1,800.00 ¤ 0.00 OK 0.4 true

6 Rockin And Rollin 60 Newbury Rd Carlsen NY 10554 (212) 555-9639 (212) 555-9630 Johnson@RockinAndRollin.com www.RockinAndRollin.com 12/31/14 ¤ 500.00 ¤ 1,205.63 OK 0.3 true

7 Mary’s Merchandise 95 south Main Street Summerville CT 06028 (860) 555-1285 (860) 555-1286 Tierney@MarysMerchandise.com www.MarysMerchandise.com 12/14/98 ¤ 4,200.00 ¤ 580.00 OK 6/4/08 0.35 true

8 World’s Best Toys 54 Oak Street New Town NY 10555 (212) 555-7774 (212) 555-7755 joann@WorldsBestToys.com www.WorldsBestToys.com ¤ 0.00 ¤ 0.00 OK 0.3 true

9 Carmen’s Collectibles 15 Hatter Drive Allison PA 15413 (724) 555-9874 (724) 555-9870 ch@CarmensCollectibles.biz www.CarmensCollectibles.biz ¤ 0.00 ¤ 0.00 OK 0.35 true

10 Red Hat Hattery 1600 Mountain Rd Montclair CA 91763 (909) 555-6666 (909) 555-6000 rob@RedHatHattery.com www.RedHatHattery.com 5/15/08 ¤ 0.00 ¤ 743.00 OK 0.3 true

11 Adorable Stuff 93 Prospect Ave Bell Gardens CA 90202 (323) 555-4777 (323) 555-4700 robbie@adorables.com www.adorables.com ¤ 0.00 ¤ 0.00 OK 0.35 true

12 All Your Needz 8 River Run Island Lake IL 60042 (847) 555-1234 (847) 555-1230 matt@AYNeedz.biz www.AYNeedz.biz 5/15/14 ¤ 0.00 ¤ 0.00 OK 0.4 true

13 Terriffic Toys 64 Highland Street Sale Creek GA 31784 (912) 555-4567 (912) 555-4500 casper@ttoys.com www.ttoys.com ¤ 0.00 ¤ 0.00 OK 0.35 true

14 Regis Toys 15 Mineral Drive Iron Springs AZ 86330 (520) 555-6888 (520) 555-6800 pete@registoys.com www.registoys.com 5/10/12 ¤ 0.00 ¤ 0.00 OK 0.45 true

15 Top End Toys 60 State Street Salado TX 76571 (254) 555-1236 (254) 555-1200 jon@topendtoys.com www.topendtoys.com ¤ 0.00 ¤ 0.00 OK 0.45 true

16 Coventry Collectibles 15 Main Street Elsa TX 78543 (956) 555-4544 (956) 555-4500 will@CoventryCollectibles.com www.CoventryCollectibles.com 6/15/12 ¤ 0.00 ¤ 98.00 OK 0.3 true

17 The Toy Box 15 Long Ave Greenleaf ID 83626 (208) 555-6914 (208) 555-6910 BigT@TheToyBox.com www.TheToyBox.com ¤ 0.00 ¤ 0.00 OK 0.35 true

18 Zoomy Collectibles 55 West North Street Knox IN 46534 (219) 555-3666 (219) 555-3660 Zoomie@ZoomyC.biz www.ZoomyC.biz 7/15/12 ¤ 0.00 ¤ 0.00 OK 0.35 true

19 Paul’s Best Toys 54 Plains Rd Turon KS 67583 (316) 555-7778 (316) 555-7770 paul@PaulsBestToys.com www.PaulsBestToys.com ¤ 0.00 ¤ 0.00 OK 0.4 true

20 Midwest Collectibles 16 South Hill Road Truxton MO 63381 (636) 555-9560 (636) 555-9566 queenie@MidwestCollectibles.biz www.MidwestCollectibles.biz ¤ 0.00 ¤ 0.00 OK 0.35 true

21 All Star Toys 971 E Main St Detroit MI 12345-6767 (989) 555-2222 (989) 555-2220 nancy@allstartoys.net www.AllStarToys.com 4/30/12 ¤ 90,000.00 ¤ 420.00 OK 1/14/07 0.35 true

22 Carl’s Collectibles 105 Main Street Columbia MA 12237 (413) 555-1989 (413) 555-1980 chamm@yahoo.com www.CarlsCollectibles.com 5/15/12 ¤ 90,000.00 ¤ 0.00 OK 2/15/08 0.35 true

23 Your Favorite Things 75 Main Street Bedford NY 10506 (518) 556-5555 (518) 556-5550 mdennis@YourFavoriteThings.com www.YourFavoriteThings.com 8/11/11 ¤ 80,000.00 ¤ 57.00 OK 3/15/08 0.4 true

24 Gleason’s 196 East Street Derby CT 06418 (860) 555-3299 (860) 555-3290 Gleason@Gleasons.biz www.Gleasons.biz 3/8/12 ¤ 80,000.00 ¤ 0.00 OK 2/26/07 0.4 true

25 Tommy’s Toys 46 School Street Oneco CT 06373 (203) 555-9101 (203) 555-9100 Alex@ttoys.com www.ttoys.com 12/5/13 ¤ 80,000.00 ¤ 958.00 OK 0.3 true

26 Too Many Toys 54 E Center Street Granby CT 06035 (860) 555-4564 (860) 555-4560 Karla@tmt.com www.tmt.com 5/31/12 ¤ 80,000.00 ¤ 168.00 OK 0.4 true

27 Grandma’s Closet 986 Buckingham St Brewster NY 10509 (212) 555-1600 (212) 555-1605 Johnm@grandmas.com www.grandmas.com 9/15/12 ¤ 80,000.00 ¤ 1,599.00 OK 0.3 true

ProductID Description Features ModelYear Make Model Color Scale QtyInStock RetailPrice Cost VendorID PictureNumber Field1

1 Buick Skylark The 1953 Skylark featured V8 power and a 12 volt electrical system, both a first for Buick, as well as full-cutout wheel openings, a styling cue that would make its way to the main 1954 Buick line. Also making its way into the 1954 Buick line was the cut-down door at the base of the side window line that bounced back up to trace around the rear window (or convertible top). This styling stayed with Buick for many years and can be found on any number of automobile brands to this day. 1953 Buick Skylark Red 1:18 1 ¤ 27.99 ¤ 16.79 3 73130 Cars

2 Cord 810 What the maker called “The New Cord Front Drive” was the only front wheel drive car built in America in that era. (An earlier Cord was manufactured from 1929 to 1932.) Today, front drive has triumphed as the preferred method of propulsion the world over. In a 1936 model, it was a curiosity. 1936 Cord 810 Black 1:18 1 ¤ 39.99 ¤ 23.99 7 18018 Cars

3 Chevrolet Corvette Convertible Every year, more and more Corvette drivers are discovering the joys of fusing the classic looks of early Vettes with the modern technology of the C4. While the first of the genre were cobbled affairs with questionable geometry and shade-tree mechanics, today there are a number of companies that produce turnkey rolling chassis ready to accept first-generation Corvette bodies. The result of this synthesis is a Corvette that’s an absolute joy to drive and open to any styling interpretation the owner chooses. 1959 Chevrolet Corvette Red 1:18 1 ¤ 25.99 ¤ 15.59 6 73216 Cars

4 Chevrolet Corvette Convertible One noteworthy addition of optional fuel injection in mid-1957 (also available on Chevrolet Bel Air). Fuel injection first saw regular use on a gasoline engine two years prior on the Mercedes-Benz 300SL “gullwing” roadster. 1957 Chevrolet Corvette Yellow 1:18 1 ¤ 21.99 ¤ 13.19 10 92018 Cars

5 Chevrolet Bel Air Convertible 1953 Chevrolet Bel Air Red 1:18 1 ¤ 34.99 ¤ 20.99 11 16202 Cars

6 Ford Fairlane 1967 Ford Fairlane Dark Red 1:18 1 ¤ 31.99 ¤ 19.19 6 18011 Cars

7 Buick T-Type 1968 Buick T-Type Gray 1:18 1 ¤ 32.99 ¤ 19.79 4 24002 Cars

8 Pontiac Vibe 2003 Pontiac Vibe Yellow 1:18 1 ¤ 19.99 ¤ 11.99 3 92508 Cars

9 Pontiac Fiero GT 2003 Pontiac Fiero Red 1:18 1 ¤ 23.14 ¤ 13.88 4 92588 Cars

10 Chrysler Crossfire 2004 Chrysler Crossfire Gray 1:18 1 ¤ 27.99 ¤ 16.79 6 73121 Cars

11 Ford Saleen Mustang 2000 Ford Mustang 1:18 1 ¤ 0.00 ¤ 0.00 9 73150 Cars

12 Chevrolet Camaro 35th Anniversary 2002 Chevrolet Camero 1:24 1 ¤ 33.00 ¤ 19.80 12 61029 Cars

13 Ford Coupe 2-Door 1932 Ford Coupe 1:18 1 ¤ 27.99 ¤ 16.79 5 92248 Cars

14 Ford Mustang 1964 Ford Mustang 1:18 1 ¤ 27.99 ¤ 16.79 7 73164 Cars

15 Ford Convertible 1937 Ford Sedan 1:18 1 ¤ 23.99 ¤ 14.39 2 92239 Cars

16 Volkswagen Beetle 2003 Volkswagen Beetle 1:18 1 ¤ 21.99 ¤ 13.19 13 25422 Cars

17 Ford Model A Pickup 1931 Ford Model A 1:18 1 ¤ 29.99 ¤ 17.99 14 18116 Trucks

18 Aston-Martin Mark II 1934 Aston-Martin Mark II 1:18 1 ¤ 44.99 ¤ 26.99 15 18118 Cars

19 Ford Crown Victoria 2000 Ford Crown Victoria 1:18 1 ¤ 24.99 ¤ 14.99 3 27136 Cars

20 Cord 812 Supercharged 1937 Cord 812 1:32 1 ¤ 25.99 ¤ 15.59 5 32312 Cars

21 Lincoln Continental 1961 Lincoln Continental 1:18 1 ¤ 55.99 ¤ 33.59 8 20088 Cars

22 Chevrolet Bel Air 1955 Chevrolet Bel Air 1:18 1 ¤ 28.00 ¤ 16.80 10 73229 Cars

23 Ford Galaxy 500 1963 Ford Galaxy 500 1:18 1 ¤ 34.99 ¤ 20.99 4 14611 Cars

24 Chevrolet Bel Air 1950 Chevrolet Bel Air 1:18 1 ¤ 27.99 ¤ 16.79 8 73111 Cars

25 Chevrolet 150 1957 Chevrolet 1:18 2 ¤ 41.99 ¤ 25.19 5 50465 Cars

26 Pontiac Bonneville 1958 Pontiac Bonneville 1:18 1 ¤ 31.99 ¤ 19.19 3 92438 Cars

27 Ford Pickup 1948 Ford 150 1:18 1 ¤ 27.99 ¤ 16.79 2 92218 Trucks

28 Chevrolet Impala 1959 Chevrolet Impala 1:18 1 ¤ 26.99 ¤ 16.19 8 92118 Cars

29 Dodge Charger 1966 Dodge Charger 1:18 1 ¤ 28.99 ¤ 17.39 7 92638 Cars

30 Ford Boss 429 Mustang 1970 Ford Mustang 1:18 1 ¤ 27.99 ¤ 16.79 5 73154 Cars

31 Honda RC211V 2003 Honda 1:9 1 ¤ 49.99 ¤ 29.99 3 10479 Motorcycle

32 Ducati Superbike 2002 Ducati 1:9 1 ¤ 49.99 ¤ 29.99 5 10451 Motorcycle

33 Shelby Coupe 1965 Shelby Coupe 1:18 1 ¤ 39.99 ¤ 23.99 6 92408 Cars

34 Porsche 935 1955 Porsche 935 1:18 2 ¤ 47.99 ¤ 28.79 14 50013 Special Interest

35 Honda F1 RA272 1965 Honda 1:12 2 ¤ 149.99 ¤ 89.99 14 23201 Special Interest

36 Watson Roadster 1959 Watson 1:18 1 ¤ 98.99 ¤ 59.39 7 44164 Special Interest

37 Kurtis Kraft #99 Art Cross 1955 SpecialInterest 1:18 1 ¤ 98.99 ¤ 59.39 7 45088 Special Interest

38 Eagle #6 Bobby Unser 1967 SpecialInterest 1:18 1 ¤ 119.99 ¤ 71.99 6 47626 Special Interest

39 AAR Eagle 1974 SpecialInterest 1:18 1 ¤ 119.99 ¤ 71.99 1 47037 Special Interest

40 Chevrolet Z-28 1967 Chevrolet Z-28 1:18 1 ¤ 29.99 ¤ 17.99 11 92188 Cars

41 Cadillac Deville Limo 2001 Cadillac Limo 1:24 1 ¤ 49.99 ¤ 29.99 3 24018 Cars

42 Lincoln Continental Limo 1961 Lincoln Limo 1:24 1 ¤ 49.99 ¤ 29.99 2 24048 Cars

43 Mercedes-Benz Pullman 1966 Mercedes 1:24 1 ¤ 54.99 ¤ 32.99 6 22032 Cars

44 Lincoln Presidental Limo 1950 Lincoln Limo 1:24 1 ¤ 59.99 ¤ 35.99 1 24058 Cars

45 Ford Woody 1948 Ford 1:18 1 ¤ 59.99 ¤ 35.99 10 20028 Cars

46 Shelby Americana Series 1999 Shelby 1:18 1 ¤ 24.99 ¤ 14.99 10 92428 Cars

47 Ford Crown Victoria 1955 Ford 1:18 3 ¤ 29.99 ¤ 17.99 5 92138 Cars

48 Chevy Nomad 1957 Chevrolet 1:18 0 ¤ 29.99 ¤ 17.99 8 92088 Cars

49 Pontiac Trans Am 1979 Pontiac 1:18 0 ¤ 39.99 ¤ 23.99 5 92378 Cars

50 Cadillac Convertible 1949 Cadillac 1:18 0 ¤ 29.99 ¤ 17.99 4 92308 Cars

51 Chevy Bel Air Hardtop 1957 Chevrolet 1:18 0 ¤ 29.99 ¤ 17.99 1 92109 Cars

53 Mercury TP Cruiser Convertible 1957 Mercury 1:18 0 ¤ 29.99 ¤ 17.99 9 92578 Cars

54 Volkswagen Microbus 1962 Volkswagen 1:18 0 ¤ 39.99 ¤ 23.99 4 92327 Trucks

55 Buick Electra 225 1959 Buick Electra 1:18 0 ¤ 39.99 ¤ 23.99 10 92598 Cars

56 Datsun 240Z 1970 Datsun 240Z 1:18 0 ¤ 29.99 ¤ 17.99 3 92528 Cars

57 Chevy Bel Air 1956 Chevrolet 1:18 0 ¤ 29.99 ¤ 17.99 13 92128 Cars

58 Tucker Torpedo 1948 Tucker Torpedo 1:18 0 ¤ 39.99 ¤ 23.99 9 92268 Cars

59 GMC Pickup 1950 GMC 1:18 0 ¤ 24.99 ¤ 14.99 6 92648 Trucks

60 Mack 75bx Pumper Fire Truck 1935 Mack 1:18 0 ¤ 54.99 ¤ 32.99 7 20098 Trucks

61 Edsel Convertible 1958 Ford Edsel 1:18 0 ¤ 29.99 ¤ 17.99 2 92298 Cars

62 Jaguar E-Type 1971 Jaguar Green 1:18 0 ¤ 29.99 ¤ 17.99 8 92609 Cars

63 MG TC Midget 1947 MG TC 1:18 0 ¤ 29.99 ¤ 17.99 1 92467 Cars

64 Cadillac DeVille Convertible 1949 Cadillac DeVille 1:18 0 ¤ 39.99 ¤ 23.99 5 92307 Cars

65 Dodge Coronet R/T 1970 Dodge Coronet 1:18 0 ¤ 29.99 ¤ 17.99 9 92548 Cars

66 Lincoln Continental MKII 1956 Lincoln Continental 1:18 0 ¤ 69.99 ¤ 41.99 9 20078 Cars

67 Ford V8 Convertible 1937 Ford 1:18 0 ¤ 29.99 ¤ 17.99 2 92237 Cars

68 Packard Caribbean Convertible 1955 Packard 1:18 0 ¤ 29.99 ¤ 17.99 8 92618 Cars

69 Plymouth Barracuda 1969 Plymouth Barracuda 1:18 0 ¤ 29.99 ¤ 17.99 5 92179 Cars

70 Plymouth Satellite 1967 Plymouth Satellite 1:18 0 ¤ 19.99 ¤ 11.99 15 50378 Cars

71 Porsche 911 The Satellite was available with the newly optional ‘Street Hemi’ engine in 1966. This engine came compete with the two 4-barrel carburetors and 10.25:1 compression. This body style remained for the following year with only minor trim changes. 1999 Porsche 1:18 0 ¤ 29.99 ¤ 17.99 4 98323 Cars

72 BMW Z4 2003 BMW Z4 1:18 0 ¤ 29.99 ¤ 17.99 12 73144 Cars

73 Mercedes Benz CLK 2002 Mercedes CLK 1:18 0 ¤ 19.99 ¤ 11.99 7 73136 Cars

74 Mercedes Benz SLK55 AMG 2005 Mercedes SLK55 1:18 0 ¤ 29.99 ¤ 17.99 11 73162 Cars

75 Lexus LS430 2002 Lexus LS430 1:18 0 ¤ 29.99 ¤ 17.99 4 73128 Cars

76 Alfa-Romeo GT Coupe 2004 Alfa-Romeo GT 1:18 0 ¤ 29.99 ¤ 17.99 11 25404 Cars

77 Ford GT40 Concept Car 2002 Ford GT40 1:18 0 ¤ 69.99 ¤ 41.99 15 73001 Special Interest

78 Dodge Viper RT/10 2003 Dodge Viper 1:18 0 ¤ 29.99 ¤ 17.99 9 73137 Cars

79 Chrysler ME Four-Twelve 2004 Chrysler 1:18 0 ¤ 29.99 ¤ 17.99 11 73138 Special Interest

80 Ford F-100 Tow Truck 1956 Ford F-100 1:18 0 ¤ 39.99 ¤ 23.99 3 19834 Trucks

81 ALF 700 Pumper Truck 1954 ALF Fire Truck 1:18 0 ¤ 29.99 ¤ 17.99 12 53509 Trucks

82 Mack CF Pumper 1968 Mack Fire Truck 1:18 0 ¤ 19.99 ¤ 11.99 12 90232 Trucks

83 E-One Rescue Truck 1999 E-One Fire Truck 1:18 0 ¤ 19.99 ¤ 11.99 5 90238 Trucks

84 White Delivery Van 1920 White Truck 1:18 0 ¤ 19.99 ¤ 11.99 15 32520 Trucks

85 Chrysler Airflow 1936 Chrysler Coupe 1:18 0 ¤ 19.99 ¤ 11.99 5 32519 Cars

86 Hudson 3 Window 1930 Hudson Coupe 1:18 0 ¤ 19.99 ¤ 11.99 10 32307 Cars

87 Ford Model T Pickup 1932 Ford Model T 1:18 0 ¤ 19.99 ¤ 11.99 6 32326 Trucks

88 Volvo XC90 2004 Volvo XC90 Blue 1:18 0 ¤ 25.99 ¤ 15.59 5 25492 Cars

89 Pontiac GTO 1969 Pontiac GTO 1:18 0 ¤ 27.99 ¤ 16.79 7 73133 Cars

90 Hummer Soft Top 2002 Hummer 1:18 0 ¤ 19.99 ¤ 11.99 3 36859 Trucks

91 Jaguar E-Type 1971 Jaguar Red 1:18 0 ¤ 29.99 ¤ 17.99 9 92608 Cars

92 Lincoln Model K 1937 Lincoln 1:18 0 ¤ 49.99 ¤ 29.99 12 18127 Cars

93 Buick Skylark 1953 Buick Skylark Blue 1:18 0 ¤ 29.99 ¤ 17.99 14 73129 Cars

94 Jeep Grand Cherokee 2001 Jeep Grand Cherokee Black 1:18 0 ¤ 27.99 ¤ 16.79 15 73123 SUV

95 Duesenberg SSJ 1935 Duesenberg 1:32 0 ¤ 19.99 ¤ 11.99 9 32218 Cars

96 Dodge Ram 1500 2002 Dodge Ram 1:18 0 ¤ 27.99 ¤ 16.79 9 73124 Trucks

97 Cadillac Biarritz 1958 Cadillac 1:18 0 ¤ 29.99 ¤ 17.99 5 92158 Cars

98 Pierce Arrow B 1930 Pierce Arrow 1:18 0 ¤ 29.99 ¤ 17.99 5 32329 Cars

99 Cadillac Town Car 1933 Cadillac Town Car 1:32 0 ¤ 19.99 ¤ 11.99 5 32327 Cars

100 Nash Healey 1953 Nash 1:18 0 ¤ 19.99 ¤ 11.99 3 32332 Cars

101 Cord 812 Supercharged 1937 Cord 812 1:18 0 ¤ 39.99 ¤ 23.99 12 18112 Cars

102 Packard Limousine 1941 Packard Limo 1:18 0 ¤ 44.99 ¤ 26.99 11 18128 Cars

103 Jaguar XK120 1949 Jaguar 1:18 0 ¤ 29.99 ¤ 17.99 13 18120 Cars

104 Duesenburg Phaeton 1934 Duesenburg 1:18 0 ¤ 49.99 ¤ 29.99 10 18110 Cars

105 Lincoln Zephyr Convertible 1939 Lincoln Zephyr 1:18 0 ¤ 49.99 ¤ 29.99 8 18102 Cars

106 Oldsmobile Super 88 1955 Oldsmobile Super 88 1:32 0 ¤ 29.99 ¤ 17.99 12 98697 Cars

107 Reo Touring 1917 Reo 1:18 0 ¤ 29.99 ¤ 17.99 10 32305 Cars

108 Buick Roadmaster 1949 Buick Roadmaster 1:32 0 ¤ 19.99 ¤ 11.99 11 32217 Cars

109 Ducati 996 2001 Ducati 1:9 0 ¤ 49.99 ¤ 29.99 2 10460 Motorcycle

110 Chrysler LeBaron 1932 Chrysler LeBaron 1:18 0 ¤ 19.99 ¤ 11.99 15 32316 Cars

111 Cleveland 40 Roadster 1920 Cleveland Coupe 1:18 0 ¤ 29.99 ¤ 17.99 14 18119 Cars

112 Chrysler Imperial 1955 Chrysler Imperial 1:18 0 ¤ 39.99 ¤ 23.99 11 18111 Cars

113 Cadillac Fleetwood 1938 Cadillac Fleetwood 1:18 0 ¤ 49.99 ¤ 29.99 15 18117 Cars

114 Studebaker Avanti 1963 Studebaker Avanti 1:18 0 ¤ 19.99 ¤ 11.99 5 32301 Cars

115 Ford Coupe 1940 Ford Coupe 1:18 0 ¤ 29.99 ¤ 17.99 5 73108 Cars

116 Chrysler Town and Country 1948 Chrysler Station Wagon 1:18 0 ¤ 19.99 ¤ 11.99 5 50045 Cars

117 Reo Touring 1917 Reo 1:18 0 ¤ 29.99 ¤ 17.99 9 18105 Cars

118 Packard LeBaron 1930 Packard 1:18 0 ¤ 39.99 ¤ 23.99 13 18115 Cars

119 Harley Davidson FLHRC Road King 2001 Harley Davidson 1:18 0 ¤ 19.99 ¤ 11.99 9 39750 Motorcycle

120 Hummer Hard Top 2002 Hummer 1:18 0 ¤ 21.99 ¤ 13.19 11 36858 Trucks

121 Ducati Monster 2001 Ducati 1:9 0 ¤ 49.99 ¤ 29.99 1 10456 Motorcycle

InvoiceNumber SaleDate InvoiceDate CustomerID SalespersonID PaymentMethod TaxRate TaxAmount Shipping

4 3/28/12 4/19/12 1 1 Check 0.05 ¤ 5,266.75 -¤ 30.00

5 5/10/12 5/4/12 18 3 Check 0.06 ¤ 13,254.00 ¤ 0.00

6 5/7/12 5/10/12 23 1 Check 0.05 ¤ 7,345.00 ¤ 0.00

7 7/5/12 7/8/12 27 1 Cash 0.0625 ¤ 8,525.00 ¤ 0.00

8 8/4/12 8/7/12 26 2 Mastercard 0.05 ¤ 6,250.00 ¤ 0.00

9 8/12/12 8/15/12 19 1 Cash 0.0625 ¤ 243.75 ¤ 0.00

10 9/25/12 9/28/12 1 3 Check 0.045 ¤ 913.50 ¤ 0.00

11 11/5/12 11/8/12 27 1 Visa 0.04 ¤ 3,041.61 ¤ 0.00

12 11/6/12 11/9/12 13 3 Visa 0.056 ¤ 4,610.48 ¤ 160.00

13 12/6/12 12/9/12 18 1 Check 0.06 ¤ 1,134.00 ¤ 0.00

14 12/11/12 12/14/12 7 2 Cash 0.04 ¤ 1,559.80 ¤ 0.00

15 2/23/13 2/26/13 27 1 COD 0.04 ¤ 70.00 ¤ 0.00

16 2/22/13 2/25/13 8 3 0.05 ¤ 625.00 ¤ 160.00

17 5/8/13 5/11/13 15 1 Discover 0.05 ¤ 1,759.10 ¤ 0.00

18 5/8/13 5/11/13 10 0 0.06 ¤ 1,890.00 ¤ 0.00

19 11/12/12 11/15/12 18 1 Other 0.05 ¤ 1,095.00 ¤ 0.00

20 11/17/12 11/20/12 9 3 0.04 ¤ 1,260.00 ¤ 0.00

21 12/11/12 12/14/12 1 1 Cash 0.0625 ¤ 2,655.94 ¤ 0.00

22 12/26/12 12/29/12 6 1 Check 0.04555 ¤ 833.57 ¤ 0.00

23 1/5/13 1/8/13 27 1 0.06 ¤ 1,224.00 ¤ 0.00

24 1/6/13 1/9/13 5 1 Mastercard 0.05 ¤ 1,675.00 ¤ 0.00

25 1/10/13 1/13/13 1 1 Visa 0.04 ¤ 1,600.00 ¤ 0.00

26 1/12/13 1/15/13 25 3 Check 0.06 ¤ 2,100.00 ¤ 0.00

27 1/16/13 1/19/13 8 3 COD 0.05 ¤ 850.00 ¤ 0.00

28 1/13/13 2/5/13 6 0 0.06 ¤ 6,990.00 ¤ 0.00

29 2/12/13 2/15/13 14 1 Amex 0.045 ¤ 553.41 ¤ 0.00

30 2/25/13 2/28/13 7 0 0.05 ¤ 6,250.00 ¤ 0.00

31 3/11/13 3/14/13 5 1 Check 0.04555 ¤ 877.98 ¤ 275.00

32 3/23/13 3/26/13 4 1 Cash 0.06 ¤ 870.00 ¤ 0.00

33 3/28/13 3/31/13 10 1 Other 0.045 ¤ 1,327.50 ¤ 0.00

34 3/29/13 4/1/13 9 1 ¤ 0.00 ¤ 275.00

35 5/8/13 5/11/13 16 1 0.0625 ¤ 43.75 ¤ 0.00

36 5/10/13 5/13/13 7 3 Check 0.04555 ¤ 569.38 ¤ 0.00

37 5/9/13 5/12/13 9 3 0.05 ¤ 79.62 ¤ 0.00

38 5/13/13 5/16/13 15 3 0.06 ¤ 3,042.00 ¤ 0.00

39 6/13/13 6/16/13 8 3 Mastercard 0.05 ¤ 0.00 ¤ 0.00

40 6/18/13 6/21/13 1 3 Check 0.029 ¤ 0.00 ¤ 0.00

41 6/27/13 6/30/13 7 3 Check 0.045 ¤ 0.00 ¤ 0.00

42 6/30/13 7/3/13 13 3 Check 0.0625 ¤ 2,618.75 ¤ 0.00

43 7/13/13 7/16/13 1 3 Check 0.06 ¤ 8,100.00 ¤ 275.00

44 7/13/13 7/16/13 13 3 Check 0.0625 ¤ 2,875.00 ¤ 0.00

45 7/13/13 7/16/13 4 3 Check 0.06 ¤ 2,406.00 ¤ 0.00

46 8/25/13 8/28/13 12 3 Check 0.045 ¤ 1,674.00 ¤ 0.00

47 8/27/13 8/30/13 12 3 Other 0.0625 ¤ 2,143.12 ¤ 0.00

48 8/27/13 8/30/13 2 3 Check 0.06 ¤ 1,274.94 ¤ 0.00

49 9/20/13 9/24/13 15 3 Check 0.0725 ¤ 1,776.25 ¤ 0.00

50 10/1/13 10/4/13 23 3 Check 0.04 ¤ 680.00 ¤ 0.00

51 10/6/13 10/9/13 5 3 Check 0.06 ¤ 9,990.00 ¤ 0.00

52 10/6/13 10/9/13 7 3 Check 0.05 ¤ 35.00 ¤ 0.00

53 10/14/13 10/17/13 19 3 Check 0.0625 ¤ 1,750.00 ¤ 0.00

54 10/15/13 10/18/13 19 3 Check 0.06 ¤ 2,448.00 ¤ 0.00

55 11/9/13 11/14/13 18 2 Other 0.04 ¤ 0.00 ¤ 0.00

56 11/22/13 11/25/13 23 2 Check 0.05 ¤ 1,095.00 ¤ 0.00

57 4/17/09 5/19/09 14 0 Check 0.045 ¤ 0.00 ¤ 0.00

58 5/10/13 5/13/13 15 3 Check 0.04555 ¤ 569.38 ¤ 0.00

SalesLineItemID InvoiceNumber ProductID Quantity RetailPrice DiscountPercent SellingPrice ExtendedPrice

5 4 59 1 ¤ 24.99 0.0 ¤ 24.99 ¤ 24.99

6 4 45 1 ¤ 59.99 0.0 ¤ 59.99 ¤ 59.99

8 4 2 1 ¤ 39.99 0.0 ¤ 39.99 ¤ 39.99

9 5 4 5 ¤ 21.99 0.35 ¤ 14.29 ¤ 71.47

10 5 34 1 ¤ 47.99 0.35 ¤ 31.19 ¤ 31.19

11 5 5 2 ¤ 34.99 0.35 ¤ 22.74 ¤ 45.49

12 5 3 1 ¤ 25.99 0.35 ¤ 16.89 ¤ 16.89

13 6 6 3 ¤ 31.99 0.0 ¤ 31.99 ¤ 95.97

14 6 8 1 ¤ 19.99 0.0 ¤ 19.99 ¤ 19.99

15 7 2 1 ¤ 39.99 0.3 ¤ 27.99 ¤ 27.99

16 7 7 4 ¤ 32.99 0.3 ¤ 23.09 ¤ 92.37

17 7 57 1 ¤ 29.99 0.3 ¤ 20.99 ¤ 20.99

18 8 51 3 ¤ 29.99 0.0 ¤ 29.99 ¤ 89.97

19 8 38 1 ¤ 119.99 0.0 ¤ 119.99 ¤ 119.99

23 8 1 3 ¤ 27.99 0.0 ¤ 27.99 ¤ 83.97

24 8 8 1 ¤ 19.99 0.0 ¤ 19.99 ¤ 19.99

25 9 56 1 ¤ 29.99 0.0 ¤ 29.99 ¤ 29.99

26 9 1 1 ¤ 27.99 0.0 ¤ 27.99 ¤ 27.99

27 10 33 3 ¤ 39.99 0.35 ¤ 25.99 ¤ 77.98

28 11 5 1 ¤ 34.99 0.3 ¤ 24.49 ¤ 24.49

29 11 17 1 ¤ 29.99 0.3 ¤ 20.99 ¤ 20.99

30 12 6 1 ¤ 31.99 0.0 ¤ 31.99 ¤ 31.99

31 13 2 9 ¤ 39.99 0.0 ¤ 39.99 ¤ 359.91

32 14 6 4 ¤ 31.99 0.0 ¤ 31.99 ¤ 127.96

33 15 1 1 ¤ 27.99 0.3 ¤ 19.59 ¤ 19.59

34 15 19 1 ¤ 24.99 0.3 ¤ 17.49 ¤ 17.49

35 16 29 2 ¤ 28.99 0.35 ¤ 18.84 ¤ 37.69

36 17 32 1 ¤ 49.99 0.45 ¤ 27.49 ¤ 27.49

37 18 59 4 ¤ 24.99 0.3 ¤ 17.49 ¤ 69.97

38 19 24 1 ¤ 27.99 0.0 ¤ 27.99 ¤ 27.99

39 20 22 1 ¤ 28.00 0.35 ¤ 18.20 ¤ 18.20

40 20 25 1 ¤ 41.99 0.35 ¤ 27.29 ¤ 27.29

41 20 16 5 ¤ 21.99 0.35 ¤ 14.29 ¤ 71.47

42 21 24 1 ¤ 27.99 0.35 ¤ 18.19 ¤ 18.19

43 21 8 1 ¤ 19.99 0.35 ¤ 12.99 ¤ 12.99

44 22 23 2 ¤ 34.99 0.0 ¤ 34.99 ¤ 69.98

45 22 15 7 ¤ 23.99 0.0 ¤ 23.99 ¤ 167.93

46 22 23 1 ¤ 34.99 0.0 ¤ 34.99 ¤ 34.99

47 23 7 1 ¤ 32.99 0.3 ¤ 23.09 ¤ 23.09

48 24 4 5 ¤ 21.99 0.0 ¤ 21.99 ¤ 109.95

49 25 30 1 ¤ 27.99 0.35 ¤ 18.19 ¤ 18.19

50 26 55 1 ¤ 39.99 0.0 ¤ 39.99 ¤ 39.99

51 27 2 6 ¤ 39.99 0.0 ¤ 39.99 ¤ 239.94

52 28 7 3 ¤ 32.99 0.0 ¤ 32.99 ¤ 98.97

53 29 15 1 ¤ 23.99 0.0 ¤ 23.99 ¤ 23.99

54 29 17 1 ¤ 29.99 0.0 ¤ 29.99 ¤ 29.99

55 30 33 1 ¤ 39.99 0.3 ¤ 27.99 ¤ 27.99

56 31 4 1 ¤ 21.99 0.0 ¤ 21.99 ¤ 21.99

57 32 14 1 ¤ 27.99 0.0 ¤ 27.99 ¤ 27.99

58 33 16 1 ¤ 21.99 0.3 ¤ 15.39 ¤ 15.39

59 34 15 1 ¤ 23.99 0.35 ¤ 15.59 ¤ 15.59

60 35 34 2 ¤ 47.99 0.0 ¤ 47.99 ¤ 95.98

61 36 23 1 ¤ 34.99 0.35 ¤ 22.74 ¤ 22.74

62 37 35 2 ¤ 149.99 0.35 ¤ 97.49 ¤ 194.99

63 38 2 1 ¤ 39.99 0.45 ¤ 21.99 ¤ 21.99

64 38 16 1 ¤ 21.99 0.45 ¤ 12.09 ¤ 12.09

65 39 43 5 ¤ 54.99 0.35 ¤ 35.74 ¤ 178.72

66 40 9 1 ¤ 23.14 0.35 ¤ 15.04 ¤ 15.04

67 41 6 3 ¤ 31.99 0.3 ¤ 22.39 ¤ 67.18

68 41 17 1 ¤ 29.99 0.3 ¤ 20.99 ¤ 20.99

69 42 24 1 ¤ 27.99 0.0 ¤ 27.99 ¤ 27.99

70 42 42 1 ¤ 49.99 0.0 ¤ 49.99 ¤ 49.99

71 42 35 1 ¤ 149.99 0.0 ¤ 149.99 ¤ 149.99

72 43 37 1 ¤ 98.99 0.35 ¤ 64.34 ¤ 64.34

73 43 2 1 ¤ 39.99 0.35 ¤ 25.99 ¤ 25.99

74 44 44 1 ¤ 59.99 0.3 ¤ 41.99 ¤ 41.99

75 45 53 2 ¤ 29.99 0.0 ¤ 29.99 ¤ 59.98

76 45 44 1 ¤ 59.99 0.0 ¤ 59.99 ¤ 59.99

77 45 23 1 ¤ 34.99 0.0 ¤ 34.99 ¤ 34.99

78 46 26 1 ¤ 31.99 0.35 ¤ 20.79 ¤ 20.79

79 47 35 2 ¤ 149.99 0.35 ¤ 97.49 ¤ 194.99

81 47 16 1 ¤ 21.99 0.45 ¤ 12.09 ¤ 12.09

82 49 35 6 ¤ 149.99 0.45 ¤ 82.49 ¤ 494.97

83 50 16 1 ¤ 21.99 0.3 ¤ 15.39 ¤ 15.39

84 51 9 1 ¤ 23.14 0.45 ¤ 12.73 ¤ 12.73

85 52 15 4 ¤ 23.99 0.35 ¤ 15.59 ¤ 62.37

86 53 25 1 ¤ 41.99 0.0 ¤ 41.99 ¤ 41.99

87 54 27 2 ¤ 27.99 0.0 ¤ 27.99 ¤ 55.98

88 55 34 1 ¤ 47.99 0.35 ¤ 31.19 ¤ 31.19

89 55 58 3 ¤ 39.99 0.35 ¤ 25.99 ¤ 77.98

90 56 2 1 ¤ 39.99 0.0 ¤ 39.99 ¤ 39.99

91 56 9 3 ¤ 23.14 0.0 ¤ 23.14 ¤ 69.42

92 56 7 1 ¤ 32.99 0.0 ¤ 32.99 ¤ 32.99

93 57 26 1 ¤ 31.99 0.0 ¤ 31.99 ¤ 31.99

94 57 25 1 ¤ 41.99 0.0 ¤ 41.99 ¤ 41.99

95 58 15 4 ¤ 23.99 0.0 ¤ 23.99 ¤ 95.96

96 58 6 3 ¤ 31.99 0.0 ¤ 31.99 ¤ 95.97

97 58 17 1 ¤ 29.99 0.0 ¤ 29.99 ¤ 29.99

SELECT tblVendors.VendorID, tblVendors.VendorName
FROM tblVendors
ORDER BY tblVendors.VendorName;
SELECT Category
FROM tblCategories
ORDER BY Category;

Looking for this or a Similar Assignment? Click below to Place your Order