-- 2. Using the tables in the HR schema, write a query to get the following employee details. To keep it -- simple, the column names from the result set below are the column names form the database.

You can join tables with multiple columns. That is, you can create a query that matches rows from the two tables only if they satisfy multiple conditions. If the database contains a relationship ...