IN SQL Query ?: DEPARTMENT (dID, Name, address, city, postal code, state, phone, email) Sales( sID, dID, employeeID, dat

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

IN SQL Query ?: DEPARTMENT (dID, Name, address, city, postal code, state, phone, email) Sales( sID, dID, employeeID, dat

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply