Solved an interesting SQL challenge on StrataScratch today: "Write a query to calculate the longest period (in days) that the company has gone without hiring anyone. Also, calculate the longest period ...

t1.timestamp::date as date, -- Command :: converts "timestamp" to just the date min(t2.timestamp::TIMESTAMP) - max(t1.timestamp::TIMESTAMP) as session_duration -- Converting "timestamp" to just the ...

Hello Data Fam! 🌈 Excited to share an interesting SQL Challenge, found from StrataScratch. SQL Challenge : Top 5 States With 5 Star ⭐ Businesses . Problem Statement: Find the top 5 states with the ...

Find the number of times the words 'bull' and 'bear' occur in the contents. We're counting the number of times the words occur so words like 'bullish' should not be ...