IN SQL Query ?: DEPARTMENT (dID, Name, address, city, postal code, state, phone, email) Sales( sID, dID, employeeID, dat
Posted: Mon Jul 11, 2022 9:49 am
IN SQL Query ?: DEPARTMENT (dID, Name, address, city, postalcode, state, phone, email)
Sales( sID, dID, employeeID, date, type, amount)
products (dID, PID,description, date, price)
stock (sID, dID, stockID, date, type, amount)
Give a report of all the products that have beenssled for more than two years and are not sold at everydepartment in the city of LA. it should include the departmentname, the product ID, the description, the date of the stock, andthe sales amount of the product.
Sales( sID, dID, employeeID, date, type, amount)
products (dID, PID,description, date, price)
stock (sID, dID, stockID, date, type, amount)
Give a report of all the products that have beenssled for more than two years and are not sold at everydepartment in the city of LA. it should include the departmentname, the product ID, the description, the date of the stock, andthe sales amount of the product.