Answer to Question #259480 in Databases | SQL | Oracle | MS Access for Agy

Question

SQL Statements to:

a) Find Total sales for a particular date

b) List available items having a given color

c) List available stock of clothes on a particular date with their accompanying including the store with that stock

d) List new stock received on a given date (order by branch)

The following stored procedures are required :

a) Return store details showing purchases done on a given date and the current stock of a given product

b) The system should ensure that during the quality check, if the product has a defect, it should be recorded in the

defect table and an appropriate message should be displayed

Answer 1

a) SELECT SUM(amount) FROM sales WHERE date= '2021-09-10';
b) SELECT DISTINCT item_name FROM items WHERE color = 'red';
c) SELECT DISTINCT store_name, stock_name from store, stock date= '2020-09-10';
d) SELECT * FROM stock ORDER BY branch