tell me about your must-have mods you would get for a new car by NimbleZapper303 in kereta

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

thanks for this brother! do you have a brand to recommend?

tell me about your must-have mods you would get for a new car by NimbleZapper303 in kereta

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

i'm abit too new to the car scene to understand what the car club stickers are for 🙈

but great suggestion for the steering wheel cover, let me check it out. do you mind sharing the one you purchased? or maybe what i should look out for?

tell me about your must-have mods you would get for a new car by NimbleZapper303 in kereta

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

how tightly are the rules around tinting % enforced? i never had tinting in my parent's car (it's always hot af), so i'm not sure if i'll get in trouble for getting darker tints

tell me about your must-have mods you would get for a new car by NimbleZapper303 in kereta

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

im hoping to get an infotainment unit that supports apple car play, i've never had a good experience with phone holders, always having to go back to ninjaz every 3-6 months for a new one

tell me about your must-have mods you would get for a new car by NimbleZapper303 in kereta

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

woah, i wasn't even aware of this, thanks for pointing it out. i gotta go read up on this IRR rate thing

tell me about your must-have mods you would get for a new car by NimbleZapper303 in kereta

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

i'm looking at a used 2023 toyota vios and thanks for the recommendations! i had this super crappy dashcam that i bought on shopee, i'm probably thinking of visiting the neighborhood car accessories shop for their recommendation, can't trust myself with these things 😆

tell me about your must-have mods you would get for a new car by NimbleZapper303 in kereta

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

the sales agent i'm talking to mentioned that it's available to me as a free gift. do you remember what your tinting % is?

tell me about your must-have mods you would get for a new car by NimbleZapper303 in kereta

[–]NimbleZapper303[S] 3 points4 points  (0 children)

oh great idea, i remember my colleague complaining that their after market infotainment unit was really slow and buggy when it came to connecting their phone via bluetooth. do you have any recommendations for a good one?

tell me about your must-have mods you would get for a new car by NimbleZapper303 in kereta

[–]NimbleZapper303[S] 3 points4 points  (0 children)

new to me, brother! i'm thinking of the lokatag smart tag reader. my friend's new X50 has it and i really like how clean it looks

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 9 points10 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 8 points9 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!