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.
IN SQL Query ?: DEPARTMENT (dID, Name, address, city, postal code, state, phone, email) Sales( sID, dID, employeeID, dat
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am