USE Study
GO

SELECT DNO, DName, LOC FROM DEPARTMENT

SELECT * FROM DEPARTMENT