Conteúdo sobre Join em SQL, com explicação, exemplos e exercícios em MySQL

Tree Utils is the library to convert and manipulate with tree-like structures.

Lab SQL Self and cross join

Примеры кода SQL-запросов из наиболее сложных решённых задач. Есть полное описание задач и ссылки на источники.

An enterprise-scale SQL logistics audit diagnosing spatial and temporal fulfillment friction across 32M+ transaction rows to optimize warehouse routing and labor utilization.

A repository of more advanced SQL Server queries, including Common Table Expressions (CTEs) and self-joins.

[PYTHON, FLASK, MYSQL] Connects a flask application to a MySQL database. Uses self join relationships. Shows understanding of validation with users and usernames. Demonstrates CRUD SQL manipulation and execution.

SQL laboratory project demonstrating table classification, aggregation, filtering with GROUP BY / HAVING, and relational joins including self-joins, multiple joins, and equi-joins using a personnel management database (Databases I, UNIWA).

End-to-end data cleaning and exploratory data analysis (EDA) project using MySQL. Includes duplicate detection using window functions, data standardization, null handling, data transformation, and structured SQL-based analysis on real-world layoff datasets.

Examples of SQL join techniques applied in real-world analytics projects, including inner join, left join, right join, full join, and self join.

Human Resources database

A two-phase SQL project that cleans a real-world tech layoffs dataset and performs exploratory analysis to surface trends across companies, countries, industries, and time.

ActiveRecord Self-Join Association

Find duplicates users in Sybase within Sisis Sunrise

Daily SQL practice solving LeetCode's SQL 50 study plan in MySQL — one problem, one README, one solution file at a time.

[MySQL ERD, DB, and quieries] Demonstrates understanding of self join relationship in ERD. SELF JOIN: many to many to same table. In this case.. A user can have a friend (another user from the same table).