target
Using the other tables below, create the correct SQL statement to get (SELECT) this target table.
Id
Name
Department
Salary
Project_name
1
Alice
Engineering
70000
Project Alpha
1
Alice
Engineering
70000
Project Beta
2
Bob
Engineering
65000
Project Alpha
2
Bob
Engineering
65000
Project Beta
3
Charlie
HR
60000
Project Gamma
4
David
HR
62000
Project Gamma
5
Eve
Sales
55000
Project Delta
to
of
Page
of
employees
Id
Name
Department_id
Salary
1
Alice
1
70000
2
Bob
1
65000
3
Charlie
2
60000
4
David
2
62000
5
Eve
3
55000
to
of
Page
of
departments
Id
Department_name
1
Engineering
2
HR
3
Sales
to
of
Page
of
projects
Id
Project_name
Department_id
1
Project Alpha
1
2
Project Beta
1
3
Project Gamma
2
4
Project Delta
3
to
of
Page
of
Answer
(0 / 7)
No output.
TARGET
Id
Name
1
Alice
1
Alice
2
Bob
2
Bob
3
Charlie
4
David
5
Eve
to
of
Page
of
SQL Query