IN SQL Query ?: DEPARTMENT (DID, DName, address, city, postal code, state, phone, email) Sales( SID, DID, employeeID, da
Posted: Sun Jul 10, 2022 11:27 am
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.
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.