information system question microsoft access sql 5152072

Information System Question (Microsoft Access – SQL)

———————————————————————-

Please solve the problem below.

————————————————————————–

List all items that were sold for at least 30% more than cost in the month of December. Hint: Use the function MONTH(date) to return the month of a date.

—————————————————————————

Inventory ItemID Description ListPrice Cost QuantityOnHand Category $1.75 $1.25 1223 Dog Food 3 DOG Dog Brush Dog Toothbrush

Order Click to Add EmployeelD OrderID OrderDate CID 1/15/2016 12200 8 10 2/14/2016 12305 6 12 2/23/2015 12306 7 16 3/1/2016 1

Orderltem Quantity SalePrice Click to Add OrderID ItemID $1.75 12200 1223 11 $3.75 12305 1224 1 $6.00 12306 1504 2 $1.00 1245

Inventory ItemID Description ListPrice Cost QuantityOnHand Category $1.75 $1.25 1223 Dog Food 3 DOG Dog Brush Dog Toothbrush 1224 $3.75 $4.10 $2.75 20 DOG $3.50 1225 2 DOG 1300 $1.50 $3.75 $0.50 Cat Food 2 CAT $2.75 1302 Cat Toy 25 CAT $4.50 $3.75 1502 Spade 15 GAR $5.99 $4.80 1504 Rake 10 GAR 3445 $3.00 $2.50 Hammer 23 TOOL $4.25 $3.75 3446 Hammer 15 TOOL Wrench $4.75 $4.10 8766 18 TOOL Wrench $5.50 $4.75 8776 12 TOOL $275.00 $0.00 $216.00 $0.00 9765 Archway 2 FLO C Order Click to Add EmployeelD OrderID OrderDate CID 1/15/2016 12200 8 10 2/14/2016 12305 6 12 2/23/2015 12306 7 16 3/1/2016 12456 12 3/7/2015 12457 1 17 3/12/2016 12458 12 6/2/2015 12459 2 11 6/12/2015 13 12470 6/17/2014 12471 5 13 6/20/2014 12472 4 17 6/28/2014 12480 3 11 7/15/2014 12500 1 14 7/15/2014 12501 4 15 11/15/2014 12502 6 17 11/23/2015 12503 5 11 12/3/2015 12504 3 10 12/30/2014 12602 1 15 12/30/2014 12948 3 16 0 0 + + + + + + + + + + + + + + Orderltem Quantity SalePrice Click to Add OrderID ItemID $1.75 12200 1223 11 $3.75 12305 1224 1 $6.00 12306 1504 2 $1.00 12456 1300 1 $5.00 12457 8776 1 $2.00 12458 1223 2 $1.00 12459 1300 2 $3.75 12470 1224 2 $4.10 12470 1225 1 $3.50 12471 1224 1 $4.00 12500 1224 2 $5.00 12500 8776 $2.00 12501 1223 3 $2.00 12502 1224 2 $2.80 12502 3445 1 $1.00 12503 1300 1 $5.00 12504 8776 1 $270.00 12602 9765 1 $1.75 12948 1223 10 $3.50 $0.00 12948 1224 1 0 0

"Get 15% discount on your first 3 orders with us"
Use the following coupon
FIRST15

Order Now