Phase 3 (SQL Query)

i. Given two tables:
Write an SQL query to show total salaries of each department along with the department name.

Employee
Id salary dept_id
1 100 2
2 200 1
3 300 2
4 100 3

Department
Id Name
1 A
2 B
3 C

Question

Phase 3 (SQL Query)

i. Given two tables: 
Write an SQL query to show total salaries of each department along with the department name.

Employee
Id    salary    dept_id
1    100    2
2    200    1
3    300    2
4    100    3

Department
Id    Name    
1    A    
2    B    
3    C

Sigiloso · Accepted Answer

Use Join and GroupBy clause and SUM function.

Pathao

Pergunta de entrevista da empresa Pathao

Resposta da entrevista

Empresas seguidas

Buscas de vagas