"Combination Lock" - CodeSignal #27 - 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 have a table discs which stores the information about these discs and has the following structure:
1. id: the unique ID of a disc;
2. characters: the list of characters the disc has (the characters are guaranteed to be unique);
3. color: the color of the disc.
Calculate the total number of all possible combinations that the lock has, and return it as a table that has only one column combinations and one row.
More CodeSignal: • CodeSignal
More LeetCode: • Leetcode
More HackerRank: • HackerRank
*******************************************************************************************
Follow me on:
Twitter - / joshuacadavez
LinkedIn - / joshuacadavez
GitHub - https://github.com/JoshuaTheEngineer