Answered step by step
Verified Expert Solution
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,
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, 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 moreStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started