New companies


Suppose you work for a conglomerate that is constantly acquiring new companies. You're working with the human resource team to understand how many new employees you're taking on. Each of the companies you are acquiring has the following organization structure:

New companies - 1
You can assume that you have all this information in the following table:

Table: allCompanyEmployees

chief_executive_officer vice_president director manager individual_contributor company_code
johnny tammy lenny penny jim abc
johnny tammy lenny penny tim abc
johnny tammy lenny penny pam abc
michael pam jerry jimmy timmy def

You can also assume that each individual's name is unique in the table for simplicity (similar to an employee ID or user name). Given the table, can you write a SQL query to print the company_code, CEO name (or ID), total number of vice presidents, total number of directors, total number of managers, and total number of individual contributors?


Access restricted

Subscribe to premium account to see the solution.

Get premium now