Execute the following Microsoft SQL Server Transact-SQL demonstration scripts in SSMS Query Editor.

USE Warehouse; -- database name

USE AdventureWorks

GO

SET SHOWPLAN_ALL  ON

GO

-- Any query here

SELECT   Department = d.Name,

         AverageVacation = avg(VacationHours)

FROM     HumanResources.Employee e

         INNER JOIN HumanResources.Department d

           ON e.DepartmentID = d.DepartmentID

GROUP BY d.Name

ORDER BY d.Name;

GO

SET SHOWPLAN_ALL  OFF

GO

Related article:

SET SHOWPLAN_ALL (Transact-SQL)