CREATE TABLE head (head_id NUMBER, name CLOB, born_state CLOB, age NUMBER)
CREATE TABLE management (department_id NUMBER, head_id NUMBER, temporary_acting CLOB)
CREATE TABLE department (department_id NUMBER, name CLOB, creation CLOB, ranking NUMBER, budget_in_billions NUMBER, num_employees NUMBER)

How many acting statuses are there?
SELECT COUNT(DISTINCT temporary_acting) FROM management
SELECT COUNT(DISTINCT "temporary_acting") FROM "management"