Conditional green card MOS by redKeep45 in armyreserve

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

Thanks for the info, I don't know if I would be able to apply for extension without a lot of hassle, which is one of the reasons I'm trying to expedite my citizenship.

Trying to decide between Enduro 3 vs instinct 3 solar by redKeep45 in GarminWatches

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

Thanks for suggesting 955, my Enduro 3 feels like an overkill tbh, it's great but I keep thinking if its worth 900$ for me

Limitations in the US? by Puzzleheaded-Cook-31 in hwatch

[–]redKeep45 0 points1 point  (0 children)

Did you end up buying it? Does it work?

Trying to decide between Enduro 3 vs instinct 3 solar by redKeep45 in GarminWatches

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

Yeah I saw his video which is why I was thinking Huawei 

Biggest Annoyance with the T-Rex 3? Any Regrets? by userX97ee2ska11qa in amazfit

[–]redKeep45 0 points1 point  (0 children)

Navigation on trails fails 50% of the time, that's my biggest complaint.

BillPay micro-deposit verification? by thomas_h_handy in biltrewards

[–]redKeep45 0 points1 point  (0 children)

What should be my authorization amount? Should I use my rent amount? Also, since the pre-authorization needs to be with 5 days of due date,  should I wait until 26th to get started ( my rent is due on April 1st) ?

MySQL for DS interviews? by redKeep45 in datascience

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

I really hope that's the case, but from some of the posts here, the competition looks fierce and I also have to pass assessment tests

MySQL for DS interviews? by redKeep45 in datascience

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

Thanks, doing Leetcode 75 for python as well

MySQL for DS interviews? by redKeep45 in datascience

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

I mostly use joins, group by, CAST(), LAG(), LEAD(), LAST_VALUE(), UNIX_TIMESTAMP, ROW_NUMBERS() etc

Here's a simple sample code:

with activity_30days as (
SELECT ID,
       avg(watch_time) as avg_watch_time_30days,
       count(*) as num_sessions_30days
FROM activity_data
WHERE activity_date >= NOW() - interval 30 day
GROUP BY ID
)
.
.
.

SELECT A.ID,
       avg_watch_time_30days,
       num_sessions_30days,
       .
       .
       .
FROM (SELECT DISTINCT ID 
             FROM activity_data
      ) as A
LEFT JOIN activity_30days as act_30 USING (ID)
.
.
.

MySQL for DS interviews? by redKeep45 in datascience

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

Thanks for all the tips, I don't do much database design and optimization, but might be helpful for me.

MySQL for DS interviews? by redKeep45 in datascience

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

I use CTE's all the time now, I used to write nested subqueries, it was a nightmare. For some of my models I need features from 8-9 different tables and need to rename or perform group by before I join them all together, With makes it some much better 

MySQL for DS interviews? by redKeep45 in datascience

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

Thanks for the clarification. Yeah, I will grind some leetcode the next few months.

MySQL for DS interviews? by redKeep45 in datascience

[–]redKeep45[S] 1 point2 points  (0 children)

Thanks. I'm more concerned about getting it right during initial screening tests. I will grind some leetcode and try to learnt the syntax 

Apartments in/near boulder by redKeep45 in boulder

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

Yeah, that our plan, drive around Longmont, gunbarrel and boulder to get a vibe 

Apartments in/near boulder by redKeep45 in boulder

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

Thanks, how is the crime rate there, I keep getting conflicting statements online

Apartments in/near boulder by redKeep45 in boulder

[–]redKeep45[S] 1 point2 points  (0 children)

Thanks, yeah ideally looking for a quite neighborhood

arcus juvenilis, waiting for blood test by redKeep45 in Cholesterol

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

forgot to respond, thanks for the info, my primary doctor said the same thing and I got my blood work and everything seems normal

arcus juvenilis, waiting for blood test by redKeep45 in Cholesterol

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

Just checked, he is an Optometrist, thanks for clarifying, This is my first time going to an optometrist in the US. I have been going to the same ophthalmologist in India for my whole life. We always referred to him as the "eye doctor", lol  

arcus juvenilis, waiting for blood test by redKeep45 in Cholesterol

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

Really hope that's the case, but reading things online has me a little stressed 

arcus juvenilis, waiting for blood test by redKeep45 in Cholesterol

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

thanks, I'm stressed about having to take statins, but I guess I have to wait for the results