challenge-sql

Endereço dos clientes (beecrowd - 2603)

Brings the names and addresses of customers who live in 'Porto Alegre'

Nenhuma Locação (beecrowd - 2616)

Brings the ID and name of customers who have not made any rentals

Concurso (beecrowd - 2738)

Shows the list of candidates, containing the name of the candidate and their final score

Produtos por categoria (beecrowd - 2609)

Displays the name and quantity of products in each category.

The payback (beecrowd - 2998)

Shows the customer's name, the initial investment, the payback month and the return value

Departamentos e Divisões (beecrowd - 2989)

Shows the name of the department, the name of its divisions, with the respective average salary and highest salary of each division

Advogados (beecrowd - 2737)

Shows the name of the lawyer who has the most clients, the name of the lawyer who has the fewest clients and the average number of clients among all lawyers.

A mensagem do sensor (beecrowd - 2995)

Shows the temperature and the corresponding number of records.

Campeonato cearense (beecrowd - 2988)

Shows team name, number of matches, wins, losses, draws and score.

Divisão com maiores médias (beecrowd - 2992)

Shows the name of the department, the name of the division with the highest average salary in the department and the average salary of the division

Pagamento dos empregados (problema - 2997)

Lists department name, employee name, gross salary, total deductions and net salary. The output must be grouped by department and division

Estatística dos departementos

Shows the name of the department, the number of employees assigned, the average salary, the highest salary and the lowest salary