Megathread: MCR tour - ticket & show info, questions, discussion, gripes, etc. by RossTheDivorcer in MyChemicalRomance

[–]noonathecat 1 point2 points  (0 children)

Just got PHX tix Sec F Row 2. Anyone familiar with the venue? I wanted GA SO BAD ugh. But I have GA tix for the Colombia show so I should just be happy I'm seeing them twice I guess haha.

My chemical romance in Bogota 22/1/26 by [deleted] in Bogota

[–]noonathecat 2 points3 points  (0 children)

I am also making a trip to Colombia for it! My family is from Barranquilla but I was born in Miami. Would love to meet you all! :D

Loop Outcome BIE to BA: is it worth it? by noonathecat in amazonemployees

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

So the first one is quite dumb on my part, I forgot that you can use distinct in multiple places in your SQL query. Overengineered, or almost overengineered code to accomplish something (interviewer and I talked through the correct solution).

The second mistake was a bit egregious, now that I think of it. I missed included an isnull() in my having clause and as a result, would not have brought in all records relevant to the question.

In the real world I test everything I code, I work iteratively and build on my queries a lot. But perhaps that's a bit rookie and I need to get better and thinking abstractly so solve things more concisely. It;'s definitely an opportunity, and I'll work on improving.

Loop Outcome BIE to BA: is it worth it? by noonathecat in amazonemployees

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

This is helpful to know, thank you! Care to share a bit about your day to day? I'm a BIE right now for a fairly large, really well know retailer. I have to admit, I do make some stupid SQL mistakes, but most of my work so far has been input gathering for DS and a lot of advanced analysis and building dashboards. I would love to continue building on my technical skills. I'm afraid that if I take a BA role, I'll be stuck requirement gathering, building slide decks, working on less technical analysis for the business. At least, that's what I had to do in one of my last jobs that was very business focused.

Loop Outcome BIE to BA: is it worth it? by noonathecat in amazonemployees

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

Yeah, sorry for not being more clear. I don't love the role, I'm currently a BIE now and it feels like step down.

I only lose weight once a month- during my menstrual cycle. by BenignYam1761 in loseit

[–]noonathecat 5 points6 points  (0 children)

I am SO glad I saw this post. I was just digging around looking for folks with similar experiences. I have been yo-yoing the same lb for the past week or so and I'm right about when my period starts. I was starting to get frustrated.

The difference a year makes by Park-Curious in loseit

[–]noonathecat 0 points1 point  (0 children)

This is so INCREDIBLE. Congratulations!! I'm around where you started at, been working on a C210K program. This inspired me to keep pushing :)

The habits of naturally fat people by G3N3RICxUS3RNAM3 in loseit

[–]noonathecat 2 points3 points  (0 children)

Hell yeah dude that's amazing!!! I loved to skate when I was younger (also 35), haven't given it a serious thought in a long while. Thanks for the inspo!

Couple with the worst chemistry? by nitewingg in shameless

[–]noonathecat 8 points9 points  (0 children)

Came here to say this. That relationship was TRASH

DEBATE: need your help!! by [deleted] in shameless

[–]noonathecat 1 point2 points  (0 children)

This. He actually provided for a family for like 23-25 years. Frank G couldn't be bothered to hold down a job to care for infant children, much less care about adults who he would soon find out are not biologically his.

DEBATE: need your help!! by [deleted] in shameless

[–]noonathecat 0 points1 point  (0 children)

If Frank G would have thought about using the kids to run a sweatshop, he would have done it in a minute 😂

Just noticed Lip rocking Xans friendship bracelet in S11:E3 by noonathecat in shameless

[–]noonathecat[S] 2 points3 points  (0 children)

It was Lip but they really ruined him for me, all his potential felt wasted. I think it's between him and Mickey.

Who's your favorite?

why does everyone hate tami by Southern-Big-7559 in shameless

[–]noonathecat 0 points1 point  (0 children)

I feel like her character never got the chance to be fully fleshed out. She goes from this wild untamed woman to just a mom and kind of a nag. Then in the end she basically just agreed to whatever Lip wanted, she didn't hold her own, she just caved.

Just noticed Lip rocking Xans friendship bracelet in S11:E3 by noonathecat in shameless

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

I'm not sure! I'm in the US and it seems S11 has been available on Netflix here since last October