LeetCode Python e SQL - Exercicios

Repositorio com exercicios simples do LeetCode resolvidos em Python e SQL. A trilha comeca pelos fundamentos da linguagem e avanca ate estruturas de dados, algoritmos e consultas em banco de dados.

Exercicios Python

Ordem	Exercicio	Tema
1	2235. Add Two Integers	Operacoes basicas
2	1480. Running Sum of 1d Array	Lista e acumulador
3	412. Fizz Buzz	Condicionais e repeticao
4	1342. Number of Steps to Reduce a Number to Zero	While e operadores
5	1672. Richest Customer Wealth	Matriz e soma
6	1929. Concatenation of Array	Listas
7	242. Valid Anagram	Strings e ordenacao
8	704. Binary Search	Busca binaria
9	121. Best Time to Buy and Sell Stock	Menor valor e maior lucro
10	20. Valid Parentheses	Pilha
11	49. Group Anagrams	Dicionario e ordenacao
12	3. Longest Substring Without Repeating Characters	Janela deslizante

Exercicios SQL

Ordem	Exercicio	Tema
1	175. Combine Two Tables	LEFT JOIN
2	181. Employees Earning More Than Their Managers	Self join
3	182. Duplicate Emails	GROUP BY e HAVING
4	183. Customers Who Never Order	LEFT JOIN e valores nulos
5	595. Big Countries	WHERE e operadores logicos
6	196. Delete Duplicate Emails	DELETE e self join
7	185. Department Top Three Salaries	Window function e DENSE_RANK
8	197. Rising Temperature	LAG e comparacao de datas
9	511. Game Play Analysis I	MIN e GROUP BY
10	577. Employee Bonus	LEFT JOIN e filtro
11	584. Find Customer Referee	WHERE e valores nulos
12	586. Customer Placing the Largest Number of Orders	GROUP BY, ORDER BY e LIMIT
13	596. Classes With at Least 5 Students	GROUP BY e HAVING
14	607. Sales Person	NOT EXISTS e subconsultas
15	610. Triangle Judgement	CASE e regras condicionais
16	619. Biggest Single Number	GROUP BY, HAVING e MAX
17	620. Not Boring Movies	WHERE, modulo e ORDER BY
18	627. Swap Sex of Employees	UPDATE e IF
19	1050. Actors and Directors Who Cooperated At Least Three Times	GROUP BY e HAVING
20	1068. Product Sales Analysis I	LEFT JOIN
21	1075. Project Employees I	AVG, ROUND e GROUP BY
22	1084. Sales Analysis III	MIN, MAX e HAVING
23	3475. DNA Pattern Recognition	CASE e funcoes de string
24	1393. Capital Gain/Loss	CASE, SUM e GROUP BY
25	608. Tree Node	CASE e subconsulta
26	626. Exchange Seats	CASE e ordenacao
27	3497. Analyze Subscription Conversion	AVG, CASE e HAVING
28	1204. Last Person to Fit in the Bus	SUM acumulado e window function
29	178. Rank Scores	DENSE_RANK e ordenacao
30	3220. Odd and Even Transactions	CASE, SUM e GROUP BY

Como executar os testes

Entre na pasta de um exercicio e execute o arquivo de teste:

python test_solution.py

Cada solution.py segue a assinatura esperada pelo LeetCode.

As consultas SQL estao em arquivos solution.sql e seguem os nomes de tabelas e colunas definidos nos enunciados.

O indice de exercicios deste README foi feito pelo Codex.