databasefunctions - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

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

View Full Document Right Arrow Icon
Same row is AND Dif erent row OR Region Salesperson Units Sold Part a Sold in Midwest 236164 Midwest Heather 204 Part b Sold by Heather in East 5 5 8 East John 3 7 Part c Sold by Heather or in East 41396 Midwest John 297 Part d Sold by Heather or John in East 1 83 9 South Heather 474 Part e Number of East transactions 970 970 West Calista 372 Part f Number of > Average transactions Er :504 West Calista 465 Part a Region West Jil 424 Midwest West Calista 254 South Calista 4 Part b Salesperson Region East Jil 108 Heather East South Jil 96 East Jil 304 Part c Salesperson Region West Calista 259 Heather West Jil 20 East East Jil 96 South John 256 Part d Salesperson Region South John 76 Heather East Midwest John 214 John East West Jil 487 East Heather 21 Part e Region East Heather 212 East Midwest Jil 368 East Jil 298 Part f Big South John 63 FALSE South Calista 2 5 South Jil 138 South Heather 3 East Jil 16 Midwest Jil 218 Midwest Heather 208 Midwest Jil 384 South Calista 139 Midwest Calista 2 6 East Jil 63 South Jil 428 South John 232 West John 384 Midwest John 1 8 West Jil 3 7 South John 492 South Heather 4 West Jil 31 West Jil 39 West John 4 East Calista 45 Midwest John 465 South John 86 East Heather 483 South Heather 146 Midwest Jil 429 Midwest Heather 8 East John 151 South John 205 East Heather 328 West John 437 Midwest John 6 South Jil 1 2 Midwest Calista 234 West Jil 47 Midwest Heather 141 West Heather 81 South John 307 East Heather 417 East Heather 51 South Calista 105 South John 285 Midwest Calista 26 East Heather 256 South Jil 64 South Jil 130 West Calista 170 Midwest Jil 93 South Heather 68 South Calista 59 South John 13 West Jil 62 South Jil 164 West Heather 469 West Calista 125 East Heather 219 West John 27 Midwest Calista 298 Midwest John 120 East Heather 78 Midwest John 127 West Jil 78 South John 2 2 Midwest John 175 South Jil 458 West John 14 Midwest Jil 46 West Heather 129 South Calista 5 East Calista 208 South Jil 32 Midwest John 410 Midwest Heather 243 Midwest Heather 480 Midwest John 490 East Jil 394 South Heather 302 West Jil 1 6 Midwest Calista 358 Midwest Calista 427 Midwest Jil 403 East Calista 209 West John 32 Midwest Jil 127 South Jil 201 West Calista 360 South Calista 284 East John 436 South Jil 276 West Jil 402 West John 175 East Calista 452 West Jil 253 West Heather 210 Midwest Jil 2 8 Midwest Heather 194 Midwest Jil 42 West John 285 West Jil 265 Midwest John 170 West Heather 328 East Jil 5 West Heather 234 Midwest Heather 141 East Jil 156 South Jil 304 East Jil 31 Midwest Calista 37 East Jil 269 West John 264 South Calista 435 West Calista 90 South Heather 23 Midwest Calista 217 Midwest Jil 402 Midwest Jil 175 East John 324 West Jil 13 West Calista 4 6 Midwest Calista 265 Midwest Heather 103 Midwest Jil 181 East Jil 363 East Calista 384 East John 380 South John 268 Midwest Heather 17 West Calista 103 East John 325 South Calista 187 East John 363 Midwest Heather 265 West John 347 South Heather 95 West John 492 South Jil 313
Background image of page 1

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

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

This note was uploaded on 03/17/2010 for the course ACCT acct 4360 taught by Professor Robert during the Spring '10 term at DeVry Colorado Springs.

Page1 / 8

databasefunctions - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

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

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