Recursive one-to-many

create table employee( id int primary key , name varchar(50) , supervisor int references employee ); insert into employee values(10, 'Mayor Quimby', 10); insert into employee values(20, 'Superintendent Chalmers', 10); insert into employee values(30, 'Principal Skinner', 20); insert into employee values(40, 'Groundskeeper Willie', 30); insert into employee values(50, 'Edna Krabapple', 30); Select * from employee.