"Personal Hobbies" - Codesignal #29 - 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/...
You downloaded the list of suggested people and saved it in the people_hobbies table, which has the following structure:
1. name - the unique person's name;
2. hobbies - a list of hobbies the person has (this column is of the datatype set).
Given the people_hobbies table, your goal is to return the sorted names of people who have sports and reading in their list of hobbies.
More CodeSignal: • CodeSignal
More LeetCode: • Leetcode
More HackerRank: • HackerRank
*******************************************************************************************
Follow me on:
Twitter - / joshuacadavez
LinkedIn - / joshuacadavez
GitHub - https://github.com/JoshuaTheEngineer