IN SQL Query ?: DEPARTMENT (DID, DName, address, city, postal code, state, phone, email) Sales( SID, DID, employeeID, da

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, DName, address, city, postal code, state, phone, email) Sales( SID, DID, employeeID, da

Post by answerhappygod »

IN SQL Query ?:
DEPARTMENT (DID, DName, address, city, postal code, state,phone, email)
Sales( SID, DID, employeeID, date, type, amount)
the sales information of the sales done at all thedepartments in 2020. The information includesdepartment name, department ID, city, and total sales at thedepartment in 2020. The information should be displayedin decreasing order of the total Sales in each DEPARTMENT.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”