NW_SolidRose (@NW_SolidRose) header
NW_SolidRose (@NW_SolidRose) profile picture

Competitive Tekken player, Former Player Coach for RIZE Esports. Data Engineer.

Joined August 2016
Photo by NW_SolidRose (@NW_SolidRose)Photo by NW_SolidRose (@NW_SolidRose)Photo by NW_SolidRose (@NW_SolidRose)Photo by NW_SolidRose (@NW_SolidRose)Photo by NW_SolidRose (@NW_SolidRose)Photo by NW_SolidRose (@NW_SolidRose)Photo by NW_SolidRose (@NW_SolidRose)Photo by NW_SolidRose (@NW_SolidRose)Photo by NW_SolidRose (@NW_SolidRose)Photo by NW_SolidRose (@NW_SolidRose)
NW_SolidRose retweeted
Fantastic turnout for #doa6lr for #vsfightingxiv. Shoutouts to all the players & congrats to @ULTIMa_Ivanov for winning!! @NW_SolidRose & seldom sad Sam round up the top 3! Thanks to @HurricaneRev for organising. @koeitecmoeurope @TeamNINJAStudio
3
5
436
NW_SolidRose retweeted
yea we don't have time to be dealing with all that..
Leroy's d+1+2 has better tracking depending on what side he starts on. If he starts on P1, you can SSR d+1+2 but if he starts on P2, it becomes homing in this situation regardless of what side he ends up on #t8_report
5
7
114
8,673
NW_SolidRose retweeted
body
2
7
482
NW_SolidRose retweeted
5 Essential Tuple Unpacking Techniques
1
16
77
83,564
NW_SolidRose retweeted
Port Scanning using Python
13
345
4
2,396
324,248
Apache Kafka 3.8.0 was just released! 🔥 What comes with this new release? Here are the top features you should know about: 1/9 🧵 (2-minute read)
3
82
2
454
98,866
STOP creating new folders like rhis
11
942
4
4,846
427,812
DIE ONE THOUSAND DEATHS! #UMVC3 #MVC #Mahvel #MarvelVSCapcom #UG #Shorts
15
380
18
1,684
77,138
Provisioning #Kubernetes Clusters On #AWS Using #Terraform & #EKS Setting up clusters from scratch is laborious. AWS offers a robust solution for orchestrating K8s clusters with EKS. Terraform simplifies the infrastructure provisioning process axelerant.com/blog/provision… #DevOps
22
76
2,675
Multithreading in Python clearly explained:
36
183
9
1,492
394,021
NW_SolidRose retweeted
STOP dragging dates in Microsoft Excel:
6
328
4
1,476
165,900
I love going for hard reads like this
21
358
16
4,184
213,810
スト6、フレンドと豪鬼でふざけておにぎり食ってたら真豪鬼の禊っぽい技(SA2)が普通の試合でてわろた 隠し要素???
13
1,041
69
5,068
1,731,991
3 Case Study Style SQL Interview Questions: 1) Imagine you work for an e-commerce company, and they want to segment their customers based on their purchase history. How would you group customers into three segments: "High Value" (top 20% of spenders), "Medium Value" (next 30% of spenders), and "Low Value" (bottom 50% of spenders). Example Answer: To segment customers, I would start by calculating the total spend for each customer. Then, I'd rank customers by their spending and divide them into three segments: "High Value," "Medium Value," and "Low Value" based on their spending percentiles. I'd use SQL's window functions like SUM() OVER (ORDER BY spending DESC). 2) You are analysing sales data for a retail store chain. How would you find the year-over-year (YoY) growth in sales revenue for each store location for the last three years. The result should show the store location, year, and the YoY growth percentage. Example Answer: I would begin by extracting sales data for each store location for the last three years. Then, I'd calculate the YoY growth by subtracting the previous year's sales from the current year's sales and dividing by the previous year's sales. Finally, I'd present the results with the relevant store locations, years, and YoY growth percentages in an SQL query. 3) You work for a large grocery store chain and they want to optimise their inventory management. How would you identify the top 10 products that have the highest sales-to-inventory ratio. The ratio is calculated as (Total Sales / Average Inventory Value) for each product. Example Answer: To do this, I'd first calculate the total sales and average inventory value for each product. Then, I'd compute the sales-to-inventory ratio for each product. To rank the products, I would use the RANK() or DENSE_RANK() window function based on the sales-to-inventory ratio, ordering the products in descending order of their ratio (depending on how I want to handle duplicate rankings). Finally, I'd limit the query to the top 10 products. How would you get on if these came up in your interview? Let me know in the comments 👇
2
52
257
21,694
NW_SolidRose retweeted
👉 Awesome Python A curated list of awesome Python frameworks, libraries, software and resources. 🔗 github.com/vinta/awesome-pyt…
97
416
22,287
NW_SolidRose retweeted
Azure Data Factory Cookbook - Second Edition: A data engineer's guide to building and managing ETL and ELT pipelines with data integration amzn.to/43e0NCN
3
15
49
10,120
NW_SolidRose retweeted
Pdf to a txt line by line using Python
2
106
2
507
34,820
NW_SolidRose retweeted
Mastering the Basics of API with Python
4
64
1
492
127,866
ANNOUNCEMENT Iron Pride is proud to present Iron Pride May Day Tournament, a 1 day Tekken Event at Gravity Wandsworth ( London ). We will have a Tekken 8 Tournament and our friends @DQRetro will be running a Tekken Ball Tournament too.
1
16
7
34
4,459