Rohit Angira·Apr 16, 2025How to calculate variance in an unsupervised model?Great question — variance in unsupervised learning doesn’t refer to label-based error like in supervised learning, but rather to…
Rohit Angira·Mar 9, 2025— 6 Find the first and last times the maximum score was awardedLet’s break down the SQL query for finding the first and last times the maximum score was awarded step by step, including the approach…
Rohit Angira·Mar 9, 2025- 1 Find the total number of inspections with low risk in 2017SQL query step by step, explain what each part does, and then walk through an example output with key MySQL features.
Rithika Kuchanpally·Feb 6, 2025Week 1 of SQLI am happy to report that questions that seem unfathomable at first don’t make me cry anymore They are not exciting to me, cause at the end…
Rohit Angira·Dec 23, 2024Stratascratch Amazon Mysql Challenge— 3 You have been asked to compare sales of the current month, May, to those of the previous month, April. — — the company requested that…
InWrite A CatalystbySuraj Jha·Oct 1, 2024StrataScratch Review: The LeetCode for Data ScientistsIs StrataScratch truly the ultimate LeetCode alternative for data scientists, or is it just another tool that falls short of the hype?A response icon2A response icon2
Sachin Sudheer·Sep 5, 2024StrataScratch SQL Solutions — PostgreSQL— HardThe solutions provided may not be equal to the expected output in stratascratch. These are just my implementations stored for future…A response icon3A response icon3
Sachin Sudheer·Sep 3, 2024StrataScratch SQL Solutions — PostgreSQL — Meta — MediumThe solutions provided may not be equal to the expected output in stratascratch. These are just my implementations stored for future…A response icon7A response icon7
Harshit Singh·Jun 16, 2024Activity RankSQL interview question asked at Google published at stratascratch.com
Harshit Singh·Jun 4, 2024SQL interview at AmazonWrite a query that’ll identify returning active users. A returning active user is a user that has made a second purchase within 7 days of…
