#1129

Employee hierarchy

Design an employees table: an id, a name and a manager. The manager is a reference to another employee in the same table (the director has none). Columns: id — primary key; name — required; manager_id — references employees.

CREATE/ALTER/DROP biss — l-ebda SELECT fl-aħħar mhu meħtieġ.

Ir-riżultat tal-query tiegħek jidher hawn

L-ebda skema tal-bidu

Dan l-eżerċizzju jibda mingħajr tabelli — toħloqhom permezz ta' CREATE TABLE.