db2.6.1

Write the SQL statement that will answer the following and submit on looseleaf, after running in APEX.

  1. Create a cross-join that displays the last name and department name from the employees and de-partments tables.

  2. What is the result of the query that you have used for question 1?

  3. Create a query that uses a natural join to join the departments table and the locations table by the location_id column. Display the department id, department name, location id, and city.

  4. Create a query that uses a natural join to join the departments table by the location_id column. Restrict the output to only department IDs of 20 and 50. Display the department id, department name, location id, and city.

results for ""

    No results matching ""