"Interest Club" - Codesignal #28 - MySQL Solution
Try these popular MySQL tutorial books this year:
1. SQL Cookbook - O'Reilly
https://amzn.to/31mTIRz
2. SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a "learn-by-doing" approach
https://amzn.to/37lcL2G
3. SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
https://amzn.to/3o2v02H
*As an Amazon Associate I earn from qualifying purchases.
*******************************************************************************************
Like and Subscribe if you enjoy my content!
Or give advice or alternative solutions in the comments below!
Problem: https://app.codesignal.com/arcade/db/...
In order to do this, you decided to collect information about the students, which is now stored in the table people_interests, which has the following columns:
1. name - the unique name of a person;
2. interests - the set of interests or hobbies this person has, given as a comma-joined string. This column has datatype set('reading','sports','swimming','drawing','writing','acting','cooking','dancing','fishkeeping','juggling','sculpting','videogaming').
More CodeSignal: • CodeSignal
More LeetCode: • Leetcode
More HackerRank: • HackerRank
*******************************************************************************************
Follow me on:
Twitter - / joshuacadavez
LinkedIn - / joshuacadavez
GitHub - https://github.com/JoshuaTheEngineer