The Closing of a Chapter

🐈‍⬛ Life

Hi friend! How’s the week going for you?

I returned to Mountain View to pack up all my things and said goodbye to the US. Next stop: Vancouver, Canada. The plan is to stay in Vancouver for a couple of weeks and then head over to China. Not sure if I can actually get into China because of the super strict quarantine laws but fingers crossed. 🤞It’s been ten years since I’ve lived there, so I’m sure there’ll be a huge culture shock. I can’t wait to show y’all where I grew up!

It’s time to close this chapter of my life and look toward the future. 🔮

(๑*ᗜ*) Anime

Soooo no anime. I guess I’m taking an anime break.

📖 Books

I started reading Crucial Conversations - a recommendation from my friend Miki. It’s a book about how to navigate conversations to lead to your desired results. The book teaches readers how to be persuasive rather than abrasive, how to get back to productive dialogue when others blow up or clam up, and generally how to master high-stake conversations regardless of the topic, person, or relationship.

This is a topic that I didn’t find important until recently.

I think the ability to navigate difficult conversations is a skill that some people naturally have. But I definitely do not lol. It’s a book that I wish I had read earlier, but ALAS better late than never, right? I already know I will be revisiting this book and slowly applying the teachings because it’s packed with useful frameworks and examples.

---

🌻 Learning & Productivity

The study with me livestreams have helped me so much. If it weren’t for all of you that come to the livestreams, I’d be struggling so much more to get back into a routine. Just showing up makes a huge difference. Thank you tortoises. 🐢

---

👨‍💻 What I’m Working On

I’m getting back into things with building Lonely Octopus. I’m also planning a new video, which I think will be a bit different from what I’ve done in the past. I’m thinking something like half vlog and half talk - wow that rhymes. Also some shorts!

---

💻 Today’s coding challenge (SQL/Python)

🛍️ Currently active Instacart question!

Find stores that were opened in the second half of 2021 with more than 20% of their reviews being negative. A review is considered negative when the score given by a customer is below 5. Output the names of the stores together with the ratio of negative reviews to positive ones.

instacart_reviews

instacart_stores

Head on over here to answer the question!

*Btw if you’re prepping for data science interviews or just want to keep yourself sharp, Stratascratch is a great platform with 10k+ real interview questions on SQL and python coding, probability, product sense etc. You can use my code ‘tinahuang’ at checkout for 20% off ❤️

---

PS: Reply to this email about what you’d like to see in future editions of Boop’s Keyboard! I’m super new to writing a newsletter and I know there’s a lot for me to learn. ALL constructive feedback is greatly appreciated :)

-Tina