Image 1 — Didnt pass SQL test
Image 2 — Didnt pass SQL test
▲ 80 r/SQL

Didnt pass SQL test

I am applying to manager of analytics role and I was given this SQL test and 45 minutes. As someone who thought they were very strong in SQL, I was unable to complete this assignment and match the answer completely

I was able to format most of the fields as noted, used 2 cte's and use group concat in the second. My final answer looked very similar but the order of the concat looked off. Also, for some reasons my second column had $0.00 for all the companies, but I thought I was close. How difficult would you rate this exercise. Should I expect to proceed to the next round or am I cooked

u/Turbulent_Web_8278 — 12 days ago

Can a private student loan go after my house

I am in the unfortunate position of having lost my job and due to my visa issues that ensued I am having to move from US to UK. I have a house that I am renting out now. In the country that I am moving to, wages are substantially lower and I cannot continue to pay $800 in student loans monthly. It is a private student loan sofi

What would happen if I stop paying my loan. Can they get a judgement and put a lien on my house

reddit.com
u/Turbulent_Web_8278 — 29 days ago

CTO allowed me to use AI for job interview

I was sent a task for a head of data role. I explicitly asked the hiring manager if I can use AI and he said he was totally fine with that. I was given 2 hours and these 2 tasks would take me weeks or months to implement in the real world. Heck just the reading part itself would take me 2 hours. The task description was 5 pages and attached was their annual report that was 40 pages, though a lot of pages had visuals so it was more like 7 dense pages

My question is what differentiating factor is any candidate going to have? Obviously everyone is going to use AI and under such time pressure I didn’t even have time to thoroughly read the AI responses. What do you think the hiring manager was trying to accomplish here

reddit.com
u/Turbulent_Web_8278 — 30 days ago

CTO allowed me to use AI for interview

I was sent a task for a head of data role. I explicitly asked the hiring manager if I can use AI and he said he was totally fine with that. I was given 2 hours and these 2 tasks would take me weeks or months to implement in the real world. Heck just the reading part itself would take me 2 hours. The task description was 5 pages and attached was their annual report that was 40 pages, though a lot of pages had visuals so it was more like 7 dense pages

My question is what differentiating factor is any candidate going to have? Obviously everyone is going to use AI and under such time pressure I didn’t even have time to thoroughly read the AI responses. What do you think the hiring manager was trying to accomplish here

reddit.com
u/Turbulent_Web_8278 — 30 days ago

Practice project of head of data roles

Can anyone suggest a practice project that span data engineering, analysis and data science that’s mature enough o be showcased to potential tech founders and c suite

reddit.com
u/Turbulent_Web_8278 — 2 months ago

Sensitivity after tooth extraction

I recently had a tooth with a root canal extracted due to infection. There was no sensation in that tooth whatsoever but the dentists could see the infection on the x ray

The tooth right next to it also has a root canal and about 5 days after the extraction it has developed a pretty serious sentivity to hold and cold subtnaces. Could this be an effect of extraction. Should I just wait to see if the sensitivty goes away?

reddit.com
u/Turbulent_Web_8278 — 2 months ago

How to land a job quickly?

I have a pretty qualified resume but am having to abruptly having to move to the UK - masters in engineering and an MBA from a top 10 university in the US and have been in advanced analytics in bay area startups. My wife and I are moving to the UK in a couple of weeks and not having a job would put tremendous financial strain on us. I have been applying to head of data roles but no interview calls yet.

I have decided making any money is better than none while we explore the corporate culture in the UK. I am willing to take lower level roles such as a senior analyst. If I dont even get that in the meantime I am willing to take up a job that pays rent for time being. Any advice on what kind of jobs I could apply and land in a couple weeks to keep the boat afloat?

reddit.com
u/Turbulent_Web_8278 — 2 months ago

Marriage Certificate stuck in Indian Customs/ O3 Visa interview

Hi All,

I am appearing for an O3 dependent visa interview. My wife and I got married in Los Angeles and she mailed the original copy of our marriage cert using USPS. It has now been stuck in Indian customs for a week and I am losing hope that I will receive it before my interview date

Is the original absolutely needed or is there a workaround. What would happen if I just show up with a photocopy

reddit.com
u/Turbulent_Web_8278 — 2 months ago

Marriage Certificate stuck in Indian Customs/ O3 Visa interview

Hi All,

I am appearing for an O3 dependent visa interview. My wife and I got married in Los Angeles and she mailed the original copy of our marriage cert using USPS. It has now been stuck in Indian customs for a week and I am losing hope that I will receive it before my interview date

Is the original absolutely needed or is there a workaround. What would happen if I just show up with a photocopy

reddit.com
u/Turbulent_Web_8278 — 2 months ago

Marriage Certificate stuck in Indian Customs/ O3 Visa interview

Hi All,

I am appearing for an O3 dependent visa interview. My wife and I got married in Los Angeles and she mailed the original copy of our marriage cert using USPS. It has now been stuck in Indian customs for a week and I am losing hope that I will receive it before my interview date

Is the original absolutely needed or is there a workaround. What would happen if I just show up with a photocopy

reddit.com
u/Turbulent_Web_8278 — 2 months ago

Wife being overly friendly with coworker/ friend

I am having visa issues and have been out of the country and separated from my wife for 7 months now. Lately my wife seems distant and keeps crying a lot saying she’s deeply unhappy with our situation. We have plans to move to a different country but it will take another 3 months to do so. She says she holds a lot of resentment from a rough patch we were in a couple months back

She also keeps mentioning this coworker who was at our wedding (my wife is friends with his gf and it’s a big group of friends) every now and then because they work together on a weekly basis. Last week, In passing she mentioned that the both of went for drinks and it was just the 2 of them and the guy was describing a fight he had with his gf and how the guy and his gf ended up crying together. Today I go to the dudes ig and he’s made some reel saying love me please or something like that and she has commented on there “love you fren no please required” this co worker also asks her to get coffee in the morning on a regular basis cus he’s running late. One time she commented on his body specifically his pot belly and then said she liked my body a lot more

I am trying to be open minded but all these things put together kind of feels weird. Am I being too jealous

reddit.com
u/Turbulent_Web_8278 — 3 months ago

AITA for thinking my wife is being overly friendly with the co worker

I am having visa issues and have been out of the country and separated from my wife for 7 months now. Lately my wife seems distant and keeps crying a lot saying she’s deeply unhappy with our situation. We have plans to move to a different country but it will take another 3 months to do so. She says she holds a lot of resentment from a rough patch we were in a couple months back

She also keeps mentioning this coworker who was at our wedding (my wife is friends with his gf and it’s a big group of friends) every now and then because they work together on a weekly basis. Last week, In passing she mentioned that the both of went for drinks and it was just the 2 of them and the guy was describing a fight he had with his gf and how the guy and his gf ended up crying together at the end. Today I go to the dudes ig and he’s made some reel saying love me please or something like that and she has commented on there “love you fren no please required” this co worker also asks her to get coffee in the morning on a regular basis cus he’s running late. One time she commented on his body specifically his pot belly and then said she liked my body a lot more

I am trying to be open minded but all these things put together kind of feels weird. Am I being too jealous

reddit.com
u/Turbulent_Web_8278 — 3 months ago

Wife being overly friendly with coworker/ friend

I am having visa issues and have been out of the country and separated from my wife for 7 months now. Lately my wife seems distant and keeps crying a lot saying she’s deeply unhappy with our situation. We have plans to move to a different country but it will take another 3 months to do so. She says she holds a lot of resentment from a rough patch we were in a couple months back

She also keeps mentioning this coworker who was at our wedding (my wife is friends with his gf and it’s a big group of friends) every now and then because they work together on a weekly basis. Last week, In passing she mentioned that the both of went for drinks and it was just the 2 of them and the guy was describing a fight he had with his gf and how the guy and his gf ended up crying together. Today I go to the dudes ig and he’s made some reel saying love me please or something like that and she has commented on there “love you fren no please required” this co worker also asks her to get coffee in the morning on a regular basis cus he’s running late. One time she commented on his body specifically his pot belly and then said she liked my body a lot more

I am trying to be open minded but all these things put together kind of feels weird. Am I being too jealous

reddit.com
u/Turbulent_Web_8278 — 3 months ago
▲ 23 r/emotionalaffair+1 crossposts

Wife being overly friendly with male friend/ coworker

I am having visa issues and have been out of the country and separated from my wife for 7 months now. Lately my wife seems distant and keeps crying a lot saying she’s deeply unhappy with our situation. We have plans to move to a different country but it will take another 3 months to do so. She says she holds a lot of resentment from a rough patch we were in a couple months back

She also keeps mentioning this coworker who was at our wedding (my wife is friends with his gf and it’s a big group of friends) every now and then because they work together on a weekly basis. Last week, In passing she mentioned that the both of went for drinks and it was just the 2 of them and the guy was describing a fight he had with his gf and how the guy and gf cried together as a result. Today I go to the dudes ig and he’s made some reel saying love me please or something like that and she has commented on there “love you fren no please required” this co worker also asks her to get coffee in the morning on a regular basis cus he’s running late. One time she commented on his body specifically his pot belly and then said she liked my body a lot more

I am trying to be open minded but all these things put together kind of feels weird. Am I being too jealous

tl;dr am I being too jealous

reddit.com
u/Turbulent_Web_8278 — 3 months ago

Marriage of 1 year, paranoid about her behavior

I have a very loving wife but we've been going thru a very rough time. I am having visa issues and weve been separated for 7 months. We has made plans to move to another country but that will take another 3 months. We have had lots of fights in this time and have discussed separation at times. Some reasons why I am being suspicious

- A friend of her was talking to a new guy while still with her bf and was considering dumping her bf for the new guy. This friend turned to my wife for advise in this matter a couple months back. My wife advised her to go with the new guy because her bf hasnt had a job for a while and this option was more practical

- One time when we were fighting I was trying to calm her down and she kept saying I have created a monster in her and called me an effing evil prick, something just didn't sit right with me when she said that. I left the conversation thinking I have no idea what other things this monster was capable of doing. I had actually called her off hours in an unexpected time and she immediately picks up the phone call and first thing she says is "what are you doing still awake"

- Off late she has been very impatient. She seems very frustrated most times when we speak. Her dad recently tried to commit suicide, which doesnt help the situation. Gets easily mad and does not calm down unless I totally back off and start saying loving things to calm her down

- Past few weekends especially Sundays she seems unavailable. We have a 12 hour time difference. She will either say that she is feeling very anxious and cant talk. Or she was napping followed by needs to talk to her mom. She will call eventually but not interested in video calls

- Recently our phone calls have been going pretty dead in the water and she will just say I dont have much to say. If I ask her about her she will just say she didn't do anything at all on a Sunday for instance

- A few days ago she mentions about having a beer with a coworker that I know who also has a gf. I know for a fact that she does not stop at a beer. Which makes me think what other times is she drinking and not telling me about it

Things that make me feel otherwise

- She is making us go to couples therapy but this is probably a positive sign

- Gives me compliments fairly occasionally

- Calls me everyday in the morning without fail

I cant bring myself to believe that she is capable of being disloyal but my gut keeps telling me something is not right. Am I being paranoid. Should I hire a PI?

TL;DR: We;re going thru a rough patch. I don't know if my wife is depressed or disinterested. We had a series of very rough fights, talked separation potentially and now I feel like I am dealing with a very different person. I can't think of anything other than whether someone else is involved

reddit.com
u/Turbulent_Web_8278 — 3 months ago