This π showcases my π HackerRank π, which prove my π₯ in ποΈ SQL & π Python through π§©, ποΈ querying & core π‘.
πΉ ποΈ SQL (π) π
πΉ π Python (π) π
πΉ π Python (π) π
β
Writing π SELECT statements to π ποΈ
β
π results using π― WHERE
β
π data using π ORDER BY
β
π’ data using π’ COUNT, β SUM, π AVG, π½ MIN, πΌ MAX
β
Using π¦ GROUP BY & π HAVING for grouped ποΈ
β
π joins: π INNER, β¬
οΈ LEFT, β‘οΈ RIGHT, π FULL
β
Using π window f(x): π RANK(), π
DENSE_RANK(), π’ ROW_NUMBER()
β
Utilizing π¦ CTEs & π subqueries
β
Advanced π aggregation & π filtering
β
π οΈ data with βοΈ UPDATE, β DELETE, β INSERT
β
π¦ Data types & π variables
β
π Conditional statements & π loops
β
π οΈ Functions & π built-in methods
β
βοΈ String manipulation
β
ποΈ Basic ποΈ (π lists, π¦ tuples, π dictionaries)