Outcomes from https://sqlbolt.com/, a great sql mini-course with playground in browser.
is a database design technique that reduces data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion Anomalies. Normalization rules divides larger tables into smaller tables and links them using relationships. The purpose of Normalization in SQL is to eliminate redundant (repetitive) data and ensure data is stored logically.
moar on https://www.guru99.com/database-normalization.html
-- complete sql query