Joins of two tables - Hackers --- Joins and Unions-2.

SESSION NAME: Joins and Unions-2.

QUESTION NAME:  Joins of two tables - Hackers.

TABLE DESCRIPTION:

Write a Query to Join the following tables

Table 1 = submissions
Table 2 = hackers

Select name field from "submission" table and join the "hackers" table using the common hacker_id column from both the table (submissions table and hackers table)

Hint: Use JOIN

CODE:

select hackers.name from submissions
JOIN hackers ON submissions.hacker_id =  hackers.hacker_id;