Case07_mmMartinMackenzie_2

Case07_mmMartinMacke - Case 7 Working with Named Tables and Logical Lookup an Author mm321374 Martin Mackenzie Date nd Database Functions DO NOT

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Case 7 - Working with Named Tables and Logical, Lookup, an Author mm321374 Martin Mackenzie Date 9/27/2009 nd Database Functions DO NOT DELETE--> 5447C621A0B290E4 645447y621w0x290a4 ll210263!lzqshm!lzbjdmyhd mm321374 Martin Mackenzie Note Date of Sale Book ID Units Sold Unit Price Gross Sales Shipping 1/4/2010 1216-12 6 $3.55 $21.30 S 1/4/2010 1236-12 14 $3.99 $55.86 P 1/4/2010 1214-11 19 $2.89 $54.91 S 1/4/2010 1271-11 26 $0.97 $25.22 S 1/5/2010 1211-12 8 $1.94 $15.52 S 1/6/2010 1211-21 19 $3.29 $62.51 P 1/6/2010 1216-11 34 $2.25 $76.50 S 1/7/2010 1251-12 20 $7.29 $145.80 P 1/8/2010 1234-12 29 $4.58 $132.82 S 1/8/2010 1274-11 27 $1.24 $33.48 S 1/11/2010 1234-13 12 $4.68 $56.16 P 1/11/2010 1254-11 19 $7.49 $142.31 P 1/12/2010 1256-11 9 $6.89 $62.01 S 1/12/2010 1274-24 22 $1.99 $43.78 P 1/12/2010 1271-24 13 $1.45 $18.85 S 1/13/2010 1216-11 16 $2.25 $36.00 S 1/13/2010 1211-21 9 $3.29 $29.61 P 1/14/2010 1211-11 12 $1.94 $23.28 S 1/14/2010 1254-12 20 $8.29 $165.80 S 1/15/2010 1211-22 19 $3.29 $62.51 P 1/15/2010 1214-11 13 $2.89 $37.57 S 1/15/2010 1236-12 24 $3.99 $95.76 P 1/18/2010 1256-11 18 $6.89 $124.02 P 1/18/2010 1234-11 13 $4.48 $58.24 S 1/18/2010 1254-11 25 $7.49 $187.25 P 1/19/2010 1274-11 14 $1.24 $17.36 S 1/19/2010 1276-12 29 $1.11 $32.19 P 1/20/2010 1274-24 9 $1.99 $17.91 S 1/20/2010 1211-12 12 $1.94 $23.28 S 1/21/2010 1251-12 18 $7.29 $131.22 S 1/22/2010 1271-11 12 $0.97 $11.64 P 1/22/2010 1231-12 24 $3.38 $81.12 S 1/25/2010 1216-11 17 $2.25 $38.25 P 1/25/2010 1234-13 25 $4.68 $117.00$117....
View Full Document

This note was uploaded on 09/27/2009 for the course BITM 110 taught by Professor Liugang during the Spring '08 term at SUNY Albany.

Page1 / 26

Case07_mmMartinMacke - Case 7 Working with Named Tables and Logical Lookup an Author mm321374 Martin Mackenzie Date nd Database Functions DO NOT

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online