Share Link
Copied to clipboard
Embed on Your Page
Copied to clipboard
We Stand with Ukraine
OrderSystemAssignment4_AmanMinhas by Aman Minhas
Customers and orders sorted by last name:
-------------------------------------------
Kevin Costner

Jacket 230.14 1
-------------------------------------------
Kevin Costner

Phone 130.25 1
-------------------------------------------
Kevin Costner

Pants 70.56 1
-------------------------------------------
Mary Jane

Pants 70.56 1
-------------------------------------------
Mary Jane

Shirt 49.99 1
-------------------------------------------
Mary Jane

Scarf 23.69 1
-------------------------------------------
Jane Kendall

Car 24200.15 1
-------------------------------------------
Jane Kendall

Shirt 49.99 1
-------------------------------------------
Jane Kendall

Scarf 23.69 1
-------------------------------------------
Donna Lynn

Car 24200.15 1
-------------------------------------------
Donna Lynn

Computer 650.00 1
-------------------------------------------
Donna Lynn

Shoes 150.23 1
-------------------------------------------
Eve Shrimp

Car 24200.15 1
-------------------------------------------
Eve Shrimp

Computer 650.00 1
-------------------------------------------
Eve Shrimp

Scarf 23.69 1
-------------------------------------------
Joe Smith

Jacket 230.14 1
-------------------------------------------
Joe Smith

Shoes 150.23 1
-------------------------------------------
Joe Smith

Phone 130.25 1
-------------------------------------------
Sally Smuthers

Jacket 230.14 1
-------------------------------------------
Sally Smuthers

Pants 70.56 1
-------------------------------------------
Sally Smuthers

Shirt 49.99 1
-------------------------------------------
Sarah Spicer

Computer 650.00 1
-------------------------------------------
Sarah Spicer

Jacket 230.14 1
-------------------------------------------
Sarah Spicer

Pants 70.56 1
-------------------------------------------
Total Number of Orders: 24

Total Number of Orders under $500: 18

Total Number of Orders over $500: 6

Total Number of Orders over $500: 76535.25

Total cost for all orders for people 30 or under: 1812.01

Total cost for all orders for people over 30: 74723.24

-------------------------------------------
The Least Expensive Products:
-------------------------------------------
Scarf 23.69 1
Shirt 49.99 1
Pants 70.56 1
-------------------------------------------
The Most Expensive Products:
-------------------------------------------
Car 24200.15 1
Computer 650.00 1
Jacket 230.14 1
-------------------------------------------
Cached Result
Last Run: 11:30:17 pm
Compile: 0.118s
Execute: 0.031s
Memory: 88kb
CPU: 0.031s