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....
New to InterviewQs? Sign up now.
By proceeding, you agree to our Terms and Conditions and Privacy Policy.
Loading editor...