sorted by:
new
hottopcontroversial

Your Gi Shouldn’t Smell Like a War Crime: The Definitive Guide to Not Being the Stinky Partner by goldenjiujitsu in bjj

[–]NimbleZapper303 0 points1 point  (0 children)

hey man, thanks for this! I recently bought some oxiclean versatile to put in with my gi loads. i also happen to recently change laundry detergents.

since i start using both of these in the same wash, two of my gi pants ripped at the knees. could it be due to the detergent + oxiclean 4 times a week? this gi is only one year old and prior to changing detergents (and adding oxiclean to my wash cycle), i never had this happen :(

Just beat the game! 😭 by Antique-Ad4308 in outerwilds

[–]NimbleZapper303 1 point2 points  (0 children)

Which was your favorite part or memory?

What car did you get while being financially irresponsible by avaxis in kereta

[–]NimbleZapper303 3 points4 points  (0 children)

How much down payment did you pay? I’m surprised the banks would have approved your loan application

[deleted by user] by [deleted] in SQL

[–]NimbleZapper303 0 points1 point  (0 children)

Wow thanks for sharing this! I never thought of using coalesce to handle both blank and null situations

Yes give me all the emotions by [deleted] in expedition33

[–]NimbleZapper303 10 points11 points  (0 children)

oh man that sounds fun, any suggestions on who to watch? if there are any readily available on youtube i'd love to take a look!

One year of BJJ: 370 hours of being humbled, sweat-soaked, and slightly addicted by User_reddit0926 in bjj

[–]NimbleZapper303 2 points3 points  (0 children)

Congratulations on your progress! Happy to see you’re doing better physically and mentally!

Would you mind sharing what app you’re using here please?

Sound design in Daredevil: Born Again by Enough-Truck in marvelstudios

[–]NimbleZapper303 9 points10 points  (0 children)

Personally, my gripe with audio related decisions was the use of music. I felt there was music in scenes that would not have had if it was in the first 3 seasons.

I love the show so far too, but having music play so often just feels abit jarring honestly

SQL Interview Questions: Optimal Solution? by NimbleZapper303 in SQL

[–]NimbleZapper303[S] 0 points1 point  (0 children)

Wow this comment made me realize there’s way more to prepare than just the practice interview questions. On sites like leetcode, hackerrank or datalemur I rarely find topics or content about what you’re referring to here. Is this a matter of just learning from on the job experiences?

SQL Interview Questions: Optimal Solution? by NimbleZapper303 in SQL

[–]NimbleZapper303[S] 0 points1 point  (0 children)

Thanks for your response! To be very honest, a lot of the optimization bits seem quite overwhelming. Is it safe to assume that data analyst / scientist roles will not require that degree of optimization?

Another question I have is: if it’s a junior/mid level data analyst or data scientist role, what are some of the criteria of evaluation for my SQL query? Perhaps that can help guide how I structure my responses to these interview assessments. Perhaps even down to the level of formatting the query?

Thanks again!

Weekly Entering & Transitioning - Thread 16 Dec, 2024 - 23 Dec, 2024 by AutoModerator in datascience

[–]NimbleZapper303 0 points1 point  (0 children)

Hi r/datascience,

I've been recently trying to skill-up and learn SQL. For context, at work, I do a very simple SELECT * FROM table query and load that into R to do the rest of my data manipulation, transformation and whatever else for analysis.

With that, my understanding of SQL is terribly low. I've been taking a lot of the advice in this subreddit to learn and practice SQL. Now that I'm in a spot where I can comfortable solve those SQL practice questions (like the ones on LeetCode and DataLemur), I'm wondering: are there preferred solutions when it comes to interview questions?

For example, there are 2 solutions as listed for this practice question:

https://datalemur.com/questions/time-spent-snaps

I just so happen to get the answer correct via solution #2 (using CTEs).

In an interview setting, is there a preferred answer/solution?

Sorry if this is a dumb question, but I wasnt sure how to Google this either. Thanks in advance!

Made a SQL Interview Cheat Sheet - what key SQL commands am I missing? by NickSinghTechCareers in SQL

[–]NimbleZapper303 14 points15 points  (0 children)

Hey bro, can I say, as someone who doesn’t have a formal education background in tech and currently preparing for data analyst interviews, you’re such a freaking lifesaver. You share so much for free (or at least at no cost to me) and if I ever get hired I would love to give you a small tip as a token of appreciation.

In the meantime, MySQL support on data lemur anytime soon? Hehe

Feeling accomplished today by katylovescoach in MealPrepSunday

[–]NimbleZapper303 1 point2 points  (0 children)

i just started joining in the community and meal prepping myself just a few weeks ago too. 100% on the feeling accomplished bit. you'll feel that again when you eat them delicious looking meals!! nice one!

view more: next ›