Query 1 Inventory Sale SalesInventory Item# Delivery 9 Invoice# Description Invoice# DO Date Quantity on Hand Item# Employee# Delivery# QuantitySold Customer# Date Delivered Selling Price
Query 1 Inventory Sale SalesInventory Item# Delivery 9 Invoice# Description Invoice# DO Date Quantity on Hand Item# Employee# Delivery# QuantitySold Customer# Date Delivered Selling Price Amount Time star Time of sale Time end Delivery# Employee# Field: Item# Description able: Inventory Inventory Sort Show 0 0 0 Criteria: or: The EM Supermarket offers both in-store shopping and order delivery services. An employee of the supermarket created the above query to see 'a list of the items that can be offered in the supermarket". Required: (a) What is wrong with this query design? (b) What results does the screenshot query actually produce? (c) Write a query using SQL to display "a list of the items that quantity on hand is less than 10". Note: you just need to use one sentence to answer each question; detailed explanations are not required
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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