Master and Master's of Master

Hard

Retrieve a list of workers, their immediate masters, and the name of the "master's master" if available. Rename the columns accordingly.

Order them by worker's name in ascending Order.

Tables Schema as Below:

$\backslash$table$[[$artisans$,$dataType$],[$columnName$,$INT$],[$id$,$VARCHAR$(255)],[$name$,$VARCHAR$(255],[$specialization$,$INT$],[$master$\_$id$,$INT$],[$experience$,$INT$],[$projectid$,]]$

master id is the id of another artisan who is tho immediate

master of the current artisan.

$$ Type here to search