Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- [Sales Representative],
- [Buyer],
- [Janitor]
- FROM
- (
- SELECT
- JobTitle,
- VacationHours
- FROM HumanResources.Employee
- ) AS A
- PIVOT(
- AVG(VacationHours)
- FOR JobTitle IN([Sales Representative], [Buyer], [Janitor])
- ) AS B
Add Comment
Please, Sign In to add comment