Occupation Query


You're given a table called "PersonOccupation", which is outlined below. Using SQL, pivot the "occupation" column so that each name is sorted alphabetically and displayed underneath its corresponding occupation. The output column headers should be data scientist, analyst, engineer, and program manager, respectively.
Table: PersonOccupation:

Column Name Data Type Description
name String Name of person
occupation string Person's occupation

Sample records for PersonOccupation:

name occupation
sally data scientist
terry analyst
mary engineer
sandy program manager
erik program manager
crystal analyst

Example query output:

data scientist analyst engineer program manager
sally crystal mary erik
NULL terry NULL sandy


Access restricted

Subscribe to premium account to see the solution.

Get premium now