This repository contains my solution for the problems in StrataScratch. StrataScratch is a data science platform with lot of interview questions from top tech companies.
The lessons learned have been listed here along with the corresponding problems where it has been applied.
| ID | Problem | Solution (Kaushik) | Solution (Official) |
|---|---|---|---|
| 9781 | Find the rate of processed tickets for each type | PostgreSQL | |
| 9782 | Customer Revenue In March | PostgreSQL, Python | |
| 9915 | Highest Cost Orders | PostgreSQL | PostgreSQL |
| 10061 | Popularity of Hack | PostgreSQL, Python | |
| 10064 | Highest Energy Consumption | PostgreSQL | PostgreSQL |
| 10078 | Find matching hosts and guests in a way that they are both of the same gender and nationality | PostgreSQL, Python | |
| 10156 | Number Of Units Per Nationality | PostgreSQL | PostgreSQL |
| 10159 | Ranking Most Active Guests | PostgreSQL | |
| 10300 | Premium vs Freemium | PostgreSQL | PostgreSQL |
| 10304 | Risky Projects | PostgreSQL | PostgreSQL |
| 10319 | Monthly Percentage Difference | PostgreSQL | PostgreSQL |
| 10322 | Finding User Purchases | Python | |
| 10351 | Activity Rank | PostgreSQL, Python | PostgreSQL, Python |
| 10354 | Most Profitable Companies | PostgreSQL, Python |
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent