Exercise

Using alias to handle same table joined queries

Often, you'll have tables that contain hierarchical data, such as employees and managers who are also employees. For this reason, you may wish to join a table to itself on different columns. The .alias() method, which creates a copy of a table, helps accomplish this task. Because it's the same table, you only need a where clause to specify the join condition.

Here, you'll use the .alias() method to build a query to join the employees table against itself to determine to whom everyone reports.

Instructions

100 XP
  • Save an alias of the employees table as managers. To do so, apply the method .alias() to employees.
  • Build a query to select the employee's name and their manager's name. The manager's name has already been selected for you. Use label to label the name column of employees as 'employee'.
  • Append a where clause to stmt to match where the id column of the managers table corresponds to the mgr column of the employees table.
  • Order the statement by the name column of the managers table.
  • Execute the statement and store all the results. This code is already written. Hit 'Submit Answer' to print the names of the managers and all their employees.