customerid order_date item quantity price 10330 30-Jun-99 Pogo stick 1 28.00 10101 30-Jun-99 Raft 1 58.00 33.00 125.00 10298 01-Jul-99 Skateboard 1 10101 01-Jul-99 Life Vest 4.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

TOPIC: SQL Select Statement for making Queries in MS Acess


Problem: Select the average price of all of the items ordered that were 
purchased in the month of Dec. 


Given Table/Data:

customerid
order_date
item
quantity
price
10330
30-Jun-99 Pogo stick
1
28.00
10101
30-Jun-99 Raft
1
58.00
01-Jul-99 Skateboard
01-Jul-99 Life Vest
10298
1
33.00
10101
4
125.00
10299
06-Jul-99 Parachute
1
1250.00
10339
27-Jul-99 Umbrella
1
4.50
13-Aug-99 Unicycle
14-Aug-99 Ski Poles
18-Aug-99 Rain Coat
01-Sep-99 Snow Shoes
18-Sep-99 Tent
19-Sep-99 Lantern
28-Oct-99 Sleeping Bag
01-Nov-99 Umbrella
10449
1
180.79
10439
25.50
10101
1
18.30
10449
1
45.00
10439
1
88.00
10298
2
29.00
10410
1
89.22
10438
1
6.75
10438
02-Nov-99 Pillow
1
8.50
10298
01-Dec-99 Helmet
1
22.00
10449
15-Dec-99 Bicycle
1
380.50
10449
22-Dec-99 Canoe
1
280.00
30-Dec-99 Hoola Hoop
01-Jan-00 Flashlight
02-Jan-00 Lantern
18-Jan-00 Inflatable Mattress
18-Jan-00 Tent
19-Jan-00 Lawnchair
30-Jan-00 Unicycle
02-Feb-00 Compass
29-Feb-00 Flashlight
08-Mar-00 Sleeping Bag
18-Mar-00 Pocket Knife
19-Mar-00 Canoe paddle
01-Аpг-00 Ear Muffs
19-Аpг-00|Shovel
10101
3
14.75
10330
4
28.00
10101
1
16.00
10299
1
38.00
10438
1
79.99
10413
4
32.00
10410
1
192.50
10315
1
8.00
10449
1
4.50
10101
2
88.70
10298
1
22.38
10449
2
40.00
10298
1
12.50
10330
1
16.75
Transcribed Image Text:customerid order_date item quantity price 10330 30-Jun-99 Pogo stick 1 28.00 10101 30-Jun-99 Raft 1 58.00 01-Jul-99 Skateboard 01-Jul-99 Life Vest 10298 1 33.00 10101 4 125.00 10299 06-Jul-99 Parachute 1 1250.00 10339 27-Jul-99 Umbrella 1 4.50 13-Aug-99 Unicycle 14-Aug-99 Ski Poles 18-Aug-99 Rain Coat 01-Sep-99 Snow Shoes 18-Sep-99 Tent 19-Sep-99 Lantern 28-Oct-99 Sleeping Bag 01-Nov-99 Umbrella 10449 1 180.79 10439 25.50 10101 1 18.30 10449 1 45.00 10439 1 88.00 10298 2 29.00 10410 1 89.22 10438 1 6.75 10438 02-Nov-99 Pillow 1 8.50 10298 01-Dec-99 Helmet 1 22.00 10449 15-Dec-99 Bicycle 1 380.50 10449 22-Dec-99 Canoe 1 280.00 30-Dec-99 Hoola Hoop 01-Jan-00 Flashlight 02-Jan-00 Lantern 18-Jan-00 Inflatable Mattress 18-Jan-00 Tent 19-Jan-00 Lawnchair 30-Jan-00 Unicycle 02-Feb-00 Compass 29-Feb-00 Flashlight 08-Mar-00 Sleeping Bag 18-Mar-00 Pocket Knife 19-Mar-00 Canoe paddle 01-Аpг-00 Ear Muffs 19-Аpг-00|Shovel 10101 3 14.75 10330 4 28.00 10101 1 16.00 10299 1 38.00 10438 1 79.99 10413 4 32.00 10410 1 192.50 10315 1 8.00 10449 1 4.50 10101 2 88.70 10298 1 22.38 10449 2 40.00 10298 1 12.50 10330 1 16.75
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY