MIS433- Module 5: Developing Reports & Forms
p_patel359
Module5.accdb| CustomerID | Company | Address | City | State | ZipCode | Phone | Fax | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | Picture_Small |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Root Entry.unknown |
| 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 |
Root Entry.unknown |
| 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 |
Root Entry.unknown |
| 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 |
Root Entry.unknown |
| 5 | Chevrolet Bel Air Convertible | 1953 | Chevrolet | Bel Air | Red | 1:18 | 1 | ¤ 34.99 | ¤ 20.99 | 11 | 16202 |
Root Entry.unknown |
|
| 6 | Ford Fairlane | 1967 | Ford | Fairlane | Dark Red | 1:18 | 1 | ¤ 31.99 | ¤ 19.19 | 6 | 18011 |
Root Entry.unknown |
|
| 7 | Buick T-Type | 1968 | Buick | T-Type | Gray | 1:18 | 1 | ¤ 32.99 | ¤ 19.79 | 4 | 24002 |
Root Entry.unknown |
|
| 8 | Pontiac Vibe | 2003 | Pontiac | Vibe | Yellow | 1:18 | 1 | ¤ 19.99 | ¤ 11.99 | 3 | 92508 |
Root Entry.unknown |
|
| 9 | Pontiac Fiero GT | 2003 | Pontiac | Fiero | Red | 1:18 | 1 | ¤ 23.14 | ¤ 13.88 | 4 | 92588 |
Root Entry.unknown |
|
| 10 | Chrysler Crossfire | 2004 | Chrysler | Crossfire | Gray | 1:18 | 1 | ¤ 27.99 | ¤ 16.79 | 6 | 73121 |
Root Entry.unknown |
|
| 11 | Ford Saleen Mustang | 2000 | Ford | Mustang | 1:18 | 1 | ¤ 0.00 | ¤ 0.00 | 9 | 73150 | |||
| 12 | Chevrolet Camaro 35th Anniversary | 2002 | Chevrolet | Camero | 1:24 | 1 | ¤ 33.00 | ¤ 19.80 | 12 | 61029 | |||
| 13 | Ford Coupe 2-Door | 1932 | Ford | Coupe | 1:18 | 1 | ¤ 27.99 | ¤ 16.79 | 5 | 92248 | |||
| 14 | Ford Mustang | 1964 | Ford | Mustang | 1:18 | 1 | ¤ 27.99 | ¤ 16.79 | 7 | 73164 | |||
| 15 | Ford Convertible | 1937 | Ford | Sedan | 1:18 | 1 | ¤ 23.99 | ¤ 14.39 | 2 | 92239 | |||
| 16 | Volkswagen Beetle | 2003 | Volkswagen | Beetle | 1:18 | 1 | ¤ 21.99 | ¤ 13.19 | 13 | 25422 | |||
| 17 | Ford Model A Pickup | 1931 | Ford | Model A | 1:18 | 1 | ¤ 29.99 | ¤ 17.99 | 14 | 18116 | |||
| 18 | Aston-Martin Mark II | 1934 | Aston-Martin | Mark II | 1:18 | 1 | ¤ 44.99 | ¤ 26.99 | 15 | 18118 | |||
| 19 | Ford Crown Victoria | 2000 | Ford | Crown Victoria | 1:18 | 1 | ¤ 24.99 | ¤ 14.99 | 3 | 27136 | |||
| 20 | Cord 812 Supercharged | 1937 | Cord | 812 | 1:32 | 1 | ¤ 25.99 | ¤ 15.59 | 5 | 32312 | |||
| 21 | Lincoln Continental | 1961 | Lincoln | Continental | 1:18 | 1 | ¤ 55.99 | ¤ 33.59 | 8 | 20088 | |||
| 22 | Chevrolet Bel Air | 1955 | Chevrolet | Bel Air | 1:18 | 1 | ¤ 28.00 | ¤ 16.80 | 10 | 73229 | |||
| 23 | Ford Galaxy 500 | 1963 | Ford | Galaxy 500 | 1:18 | 1 | ¤ 34.99 | ¤ 20.99 | 4 | 14611 | |||
| 24 | Chevrolet Bel Air | 1950 | Chevrolet | Bel Air | 1:18 | 1 | ¤ 27.99 | ¤ 16.79 | 8 | 73111 | |||
| 25 | Chevrolet 150 | 1957 | Chevrolet | 1:18 | 2 | ¤ 41.99 | ¤ 25.19 | 5 | 50465 | ||||
| 26 | Pontiac Bonneville | 1958 | Pontiac | Bonneville | 1:18 | 1 | ¤ 31.99 | ¤ 19.19 | 3 | 92438 | |||
| 27 | Ford Pickup | 1948 | Ford | 150 | 1:18 | 1 | ¤ 27.99 | ¤ 16.79 | 2 | 92218 | |||
| 28 | Chevrolet Impala | 1959 | Chevrolet | Impala | 1:18 | 1 | ¤ 26.99 | ¤ 16.19 | 8 | 92118 | |||
| 29 | Dodge Charger | 1966 | Dodge | Charger | 1:18 | 1 | ¤ 28.99 | ¤ 17.39 | 7 | 92638 | |||
| 30 | Ford Boss 429 Mustang | 1970 | Ford | Mustang | 1:18 | 1 | ¤ 27.99 | ¤ 16.79 | 5 | 73154 | |||
| 31 | Honda RC211V | 2003 | Honda | 1:9 | 1 | ¤ 49.99 | ¤ 29.99 | 3 | 10479 | ||||
| 32 | Ducati Superbike | 2002 | Ducati | 1:9 | 1 | ¤ 49.99 | ¤ 29.99 | 5 | 10451 | ||||
| 33 | Shelby Coupe | 1965 | Shelby | Coupe | 1:18 | 1 | ¤ 39.99 | ¤ 23.99 | 6 | 92408 | |||
| 34 | Porsche 935 | 1955 | Porsche | 935 | 1:18 | 2 | ¤ 47.99 | ¤ 28.79 | 14 | 50013 | |||
| 35 | Honda F1 RA272 | 1965 | Honda | 1:12 | 2 | ¤ 149.99 | ¤ 89.99 | 14 | 23201 | ||||
| 36 | Watson Roadster | 1959 | Watson | 1:18 | 1 | ¤ 98.99 | ¤ 59.39 | 7 | 44164 | ||||
| 37 | Kurtis Kraft #99 Art Cross | 1955 | SpecialInterest | 1:18 | 1 | ¤ 98.99 | ¤ 59.39 | 7 | 45088 | ||||
| 38 | Eagle #6 Bobby Unser | 1967 | SpecialInterest | 1:18 | 1 | ¤ 119.99 | ¤ 71.99 | 6 | 47626 | ||||
| 39 | AAR Eagle | 1974 | SpecialInterest | 1:18 | 1 | ¤ 119.99 | ¤ 71.99 | 1 | 47037 | ||||
| 40 | Chevrolet Z-28 | 1967 | Chevrolet | Z-28 | 1:18 | 1 | ¤ 29.99 | ¤ 17.99 | 11 | 92188 | |||
| 41 | Cadillac Deville Limo | 2001 | Cadillac | Limo | 1:24 | 1 | ¤ 49.99 | ¤ 29.99 | 3 | 24018 | |||
| 42 | Lincoln Continental Limo | 1961 | Lincoln | Limo | 1:24 | 1 | ¤ 49.99 | ¤ 29.99 | 2 | 24048 | |||
| 43 | Mercedes-Benz Pullman | 1966 | Mercedes | 1:24 | 1 | ¤ 54.99 | ¤ 32.99 | 6 | 22032 | ||||
| 44 | Lincoln Presidental Limo | 1950 | Lincoln | Limo | 1:24 | 1 | ¤ 59.99 | ¤ 35.99 | 1 | 24058 | |||
| 45 | Ford Woody | 1948 | Ford | 1:18 | 1 | ¤ 59.99 | ¤ 35.99 | 10 | 20028 | ||||
| 46 | Shelby Americana Series | 1999 | Shelby | 1:18 | 1 | ¤ 24.99 | ¤ 14.99 | 10 | 92428 | ||||
| 47 | Ford Crown Victoria | 1955 | Ford | 1:18 | 3 | ¤ 29.99 | ¤ 17.99 | 5 | 92138 | ||||
| 48 | Chevy Nomad | 1957 | Chevrolet | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 8 | 92088 | ||||
| 49 | Pontiac Trans Am | 1979 | Pontiac | 1:18 | 0 | ¤ 39.99 | ¤ 23.99 | 5 | 92378 | ||||
| 50 | Cadillac Convertible | 1949 | Cadillac | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 4 | 92308 | ||||
| 51 | Chevy Bel Air Hardtop | 1957 | Chevrolet | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 1 | 92109 | ||||
| 53 | Mercury TP Cruiser Convertible | 1957 | Mercury | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 9 | 92578 | ||||
| 54 | Volkswagen Microbus | 1962 | Volkswagen | 1:18 | 0 | ¤ 39.99 | ¤ 23.99 | 4 | 92327 | ||||
| 55 | Buick Electra 225 | 1959 | Buick | Electra | 1:18 | 0 | ¤ 39.99 | ¤ 23.99 | 10 | 92598 | |||
| 56 | Datsun 240Z | 1970 | Datsun | 240Z | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 3 | 92528 | |||
| 57 | Chevy Bel Air | 1956 | Chevrolet | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 13 | 92128 | ||||
| 58 | Tucker Torpedo | 1948 | Tucker | Torpedo | 1:18 | 0 | ¤ 39.99 | ¤ 23.99 | 9 | 92268 | |||
| 59 | GMC Pickup | 1950 | GMC | 1:18 | 0 | ¤ 24.99 | ¤ 14.99 | 6 | 92648 | ||||
| 60 | Mack 75bx Pumper Fire Truck | 1935 | Mack | 1:18 | 0 | ¤ 54.99 | ¤ 32.99 | 7 | 20098 | ||||
| 61 | Edsel Convertible | 1958 | Ford | Edsel | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 2 | 92298 | |||
| 62 | Jaguar E-Type | 1971 | Jaguar | Green | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 8 | 92609 | |||
| 63 | MG TC Midget | 1947 | MG | TC | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 1 | 92467 | |||
| 64 | Cadillac DeVille Convertible | 1949 | Cadillac | DeVille | 1:18 | 0 | ¤ 39.99 | ¤ 23.99 | 5 | 92307 | |||
| 65 | Dodge Coronet R/T | 1970 | Dodge | Coronet | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 9 | 92548 | |||
| 66 | Lincoln Continental MKII | 1956 | Lincoln | Continental | 1:18 | 0 | ¤ 69.99 | ¤ 41.99 | 9 | 20078 | |||
| 67 | Ford V8 Convertible | 1937 | Ford | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 2 | 92237 | ||||
| 68 | Packard Caribbean Convertible | 1955 | Packard | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 8 | 92618 | ||||
| 69 | Plymouth Barracuda | 1969 | Plymouth | Barracuda | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 5 | 92179 | |||
| 70 | Plymouth Satellite | 1967 | Plymouth | Satellite | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 15 | 50378 | |||
| 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 | |||
| 72 | BMW Z4 | 2003 | BMW | Z4 | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 12 | 73144 | |||
| 73 | Mercedes Benz CLK | 2002 | Mercedes | CLK | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 7 | 73136 | |||
| 74 | Mercedes Benz SLK55 AMG | 2005 | Mercedes | SLK55 | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 11 | 73162 | |||
| 75 | Lexus LS430 | 2002 | Lexus | LS430 | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 4 | 73128 | |||
| 76 | Alfa-Romeo GT Coupe | 2004 | Alfa-Romeo | GT | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 11 | 25404 | |||
| 77 | Ford GT40 Concept Car | 2002 | Ford | GT40 | 1:18 | 0 | ¤ 69.99 | ¤ 41.99 | 15 | 73001 | |||
| 78 | Dodge Viper RT/10 | 2003 | Dodge | Viper | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 9 | 73137 | |||
| 79 | Chrysler ME Four-Twelve | 2004 | Chrysler | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 11 | 73138 | ||||
| 80 | Ford F-100 Tow Truck | 1956 | Ford | F-100 | 1:18 | 0 | ¤ 39.99 | ¤ 23.99 | 3 | 19834 | |||
| 81 | ALF 700 Pumper Truck | 1954 | ALF | Fire Truck | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 12 | 53509 | |||
| 82 | Mack CF Pumper | 1968 | Mack | Fire Truck | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 12 | 90232 | |||
| 83 | E-One Rescue Truck | 1999 | E-One | Fire Truck | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 5 | 90238 | |||
| 84 | White Delivery Van | 1920 | White | Truck | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 15 | 32520 | |||
| 85 | Chrysler Airflow | 1936 | Chrysler | Coupe | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 5 | 32519 | |||
| 86 | Hudson 3 Window | 1930 | Hudson | Coupe | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 10 | 32307 | |||
| 87 | Ford Model T Pickup | 1932 | Ford | Model T | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 6 | 32326 | |||
| 88 | Volvo XC90 | 2004 | Volvo | XC90 | Blue | 1:18 | 0 | ¤ 25.99 | ¤ 15.59 | 5 | 25492 | ||
| 89 | Pontiac GTO | 1969 | Pontiac | GTO | 1:18 | 0 | ¤ 27.99 | ¤ 16.79 | 7 | 73133 | |||
| 90 | Hummer Soft Top | 2002 | Hummer | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 3 | 36859 | ||||
| 91 | Jaguar E-Type | 1971 | Jaguar | Red | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 9 | 92608 | |||
| 92 | Lincoln Model K | 1937 | Lincoln | 1:18 | 0 | ¤ 49.99 | ¤ 29.99 | 12 | 18127 | ||||
| 93 | Buick Skylark | 1953 | Buick | Skylark | Blue | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 14 | 73129 | ||
| 94 | Jeep Grand Cherokee | 2001 | Jeep | Grand Cherokee | Black | 1:18 | 0 | ¤ 27.99 | ¤ 16.79 | 15 | 73123 | ||
| 95 | Duesenberg SSJ | 1935 | Duesenberg | 1:32 | 0 | ¤ 19.99 | ¤ 11.99 | 9 | 32218 | ||||
| 96 | Dodge Ram 1500 | 2002 | Dodge | Ram | 1:18 | 0 | ¤ 27.99 | ¤ 16.79 | 9 | 73124 | |||
| 97 | Cadillac Biarritz | 1958 | Cadillac | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 5 | 92158 | ||||
| 98 | Pierce Arrow B | 1930 | Pierce Arrow | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 5 | 32329 | ||||
| 99 | Cadillac Town Car | 1933 | Cadillac | Town Car | 1:32 | 0 | ¤ 19.99 | ¤ 11.99 | 5 | 32327 | |||
| 100 | Nash Healey | 1953 | Nash | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 3 | 32332 | ||||
| 101 | Cord 812 Supercharged | 1937 | Cord | 812 | 1:18 | 0 | ¤ 39.99 | ¤ 23.99 | 12 | 18112 | |||
| 102 | Packard Limousine | 1941 | Packard | Limo | 1:18 | 0 | ¤ 44.99 | ¤ 26.99 | 11 | 18128 | |||
| 103 | Jaguar XK120 | 1949 | Jaguar | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 13 | 18120 | ||||
| 104 | Duesenburg Phaeton | 1934 | Duesenburg | 1:18 | 0 | ¤ 49.99 | ¤ 29.99 | 10 | 18110 | ||||
| 105 | Lincoln Zephyr Convertible | 1939 | Lincoln | Zephyr | 1:18 | 0 | ¤ 49.99 | ¤ 29.99 | 8 | 18102 | |||
| 106 | Oldsmobile Super 88 | 1955 | Oldsmobile | Super 88 | 1:32 | 0 | ¤ 29.99 | ¤ 17.99 | 12 | 98697 | |||
| 107 | Reo Touring | 1917 | Reo | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 10 | 32305 | ||||
| 108 | Buick Roadmaster | 1949 | Buick | Roadmaster | 1:32 | 0 | ¤ 19.99 | ¤ 11.99 | 11 | 32217 | |||
| 109 | Ducati 996 | 2001 | Ducati | 1:9 | 0 | ¤ 49.99 | ¤ 29.99 | 2 | 10460 | ||||
| 110 | Chrysler LeBaron | 1932 | Chrysler | LeBaron | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 15 | 32316 | |||
| 111 | Cleveland 40 Roadster | 1920 | Cleveland | Coupe | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 14 | 18119 | |||
| 112 | Chrysler Imperial | 1955 | Chrysler | Imperial | 1:18 | 0 | ¤ 39.99 | ¤ 23.99 | 11 | 18111 | |||
| 113 | Cadillac Fleetwood | 1938 | Cadillac | Fleetwood | 1:18 | 0 | ¤ 49.99 | ¤ 29.99 | 15 | 18117 | |||
| 114 | Studebaker Avanti | 1963 | Studebaker | Avanti | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 5 | 32301 | |||
| 115 | Ford Coupe | 1940 | Ford | Coupe | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 5 | 73108 | |||
| 116 | Chrysler Town and Country | 1948 | Chrysler | Station Wagon | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 5 | 50045 | |||
| 117 | Reo Touring | 1917 | Reo | 1:18 | 0 | ¤ 29.99 | ¤ 17.99 | 9 | 18105 | ||||
| 118 | Packard LeBaron | 1930 | Packard | 1:18 | 0 | ¤ 39.99 | ¤ 23.99 | 13 | 18115 | ||||
| 119 | Harley Davidson FLHRC Road King | 2001 | Harley Davidson | 1:18 | 0 | ¤ 19.99 | ¤ 11.99 | 9 | 39750 | ||||
| 120 | Hummer Hard Top | 2002 | Hummer | 1:18 | 0 | ¤ 21.99 | ¤ 13.19 | 11 | 36858 | ||||
| 121 | Ducati Monster | 2001 | Ducati | 1:9 | 0 | ¤ 49.99 | ¤ 29.99 | 1 | 10456 |
| 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;
SELECT DISTINCTROW *
FROM tblSales;
SELECT [tblProducts].[Description], [tblSalesLineItems].[ProductID], [tblSalesLineItems].[SellingPrice], [tblSalesLineItems].[ExtendedPrice], [tblSalesLineItems].[InvoiceNumber]
FROM tblProducts INNER JOIN tblSalesLineItems ON [tblProducts].[ProductID] =[tblSalesLineItems].[ProductID];
SELECT DISTINCTROW *
FROM tblCustomers;
SELECT DISTINCTROW *
FROM tblSales;
SELECT [tblSalesLineItems].[ProductID], [tblProducts].[Description], [tblSalesLineItems].[InvoiceNumber]
FROM tblProducts INNER JOIN tblSalesLineItems ON [tblProducts].[ProductID] =[tblSalesLineItems].[ProductID];
SELECT DISTINCTROW *
FROM tblCustomers;
