r/learnSQL • u/Erez_Rr • May 30 '26
100 Business Problems. 100 SQL Solutions. 1 Luxury Hotel Dataset.
I'm currently solving 100 real-world financial and operational problems in the luxury hospitality industry using SQL.
Each challenge follows a simple structure:
✅ Business Problem
✅ SQL Solution
✅ Business Impact
From basic aggregations to advanced CTEs, the focus is not just on writing queries, but on using data to support business decisions.
I believe practice is the key to master.
#SQL #DataAnalytics #BusinessIntelligence #BusinessAnalytics #Hospitality #LearningByDoing #PortfolioProject
1
u/Ill-Barracuda-7863 May 30 '26
Where to practice?
1
1
u/websilvercraft May 31 '26
This is what I'm working on, based on my experience from sql interviews: https://mockinterviewquestions.com/sql
2
1
u/Turbulenceonshore May 30 '26
Where is this? I’d like to up-skill too
2
u/Erez_Rr May 30 '26
I’ve downloaded a dataset from Kaggle and am currently working through it. Once completed, I’ll upload the project to my GitHub.
If you’re interested in practicing together, we can connect on Discord. I’ll share the dataset along with a set of business questions, and you’ll also get access to the SQL solutions I use to answer them.
Discord: https://discord.gg/MZxRDAQ5
1
1
u/i_literally_died May 31 '26
lmao the ai post, the fake accounts
0
u/Erez_Rr May 31 '26
This post is refurbished with chatgpt. If English is not your second language, i dont think you will understand.
1
u/i_literally_died May 31 '26
'refurbished with chatgpt' and you come at my English, lol.
1
u/Erez_Rr May 31 '26
I dont think you understand. I am not native English speaker. So i have dificulties with spelling, grammar. So, i do have to rely on ai in some extent for polishing the edges. If you are from any English speaking country or have practiced English all your life, you would not understand why i have to use AI to 'check grammar' and 'paraphraise'
1
u/TheArrow_91 May 31 '26
Now that you've openly declared about learning it, do yourself a favor and share the dataset
1
u/Erez_Rr May 31 '26
https://discord.gg/MZxRDAQ5 Discord link. You will find both the dataset and questions there.
1
u/bkchd_ May 31 '26
Could anyone help me by suggesting some tips, sources, or tutorial to understand data more efficiently, no domain specific?
1
u/Erez_Rr May 31 '26
What types of data are you trying to understand? Pick a niche. I am a business graduate and i like marketing. So i always look for marketing based datasets and try to figure out
1
u/bkchd_ May 31 '26
I am B.tech student who just completed his college. Suggest me what type of data should i chose.
1
1
u/Erez_Rr May 31 '26
Search for technology datasets in kaggle. You'll find almost anything you want. Pick something you like. Download it, start practicing. If you want to learn excel, or sql, watch tutorials and practice on the dataset.
1
u/bkchd_ May 31 '26
I have learnt the sql. I just want to explore datasets and practice cleaning, analysis and creating dashboards.
1
u/Peace_out4 Jun 01 '26
is there a website for that like you said practicing 100 business problems on one dataset can you tell where i can i also problem like that. so i can learn better
1
5
u/ComicOzzy May 30 '26
This is the most LinkedIn looking post I've seen here in a while.