Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

TAL Distrubtors Database 16. Display the results of the last query, but only show total sales above $400,000.00 17. Display the Item, description, on hand,

image text in transcribedTAL Distrubtors Database

16. Display the results of the last query, but only show total sales above $400,000.00 17. Display the Item, description, on hand, category, price and inventory value for each item in the Item table. 18. Display the Item, description, price from the inventory table. Also include a mark up and retail price for each item assuming there is a 60% mark up for all items. 19. Display the item number, description, quantity on hand and price for the items that are priced $30.00 or less. 20. Display the item number, description, quantity on hand and price for the items that are priced $30.00 or more

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Visual Basic 4 Ole Database And Controls Superbible

Authors: Michael Hatmaker, C. Woody Butler, Ibrahim Malluf, Bill Potter

1st Edition

1571690077, 978-1571690074

More Books

Students also viewed these Databases questions

Question

a min company operates at 80%

Answered: 1 week ago