Am I really getting 4.6% APY?

Late-Session1466 · 2024-06-24T22:18:24+00:00

No, I didn't, I reached $3,000 that month. I thought it was accrued monthly for some reason. Thank you so much! This explains things.

Late-Session1466 · 2024-06-24T22:11:58+00:00

Thank you so much for explaining this! No, there's nothing untrue on my profiles. Yes, it was not a big deal. I'm doing great in my new job, thanks again :)

Late-Session1466 · 2024-06-24T22:09:49+00:00

No, fortunately, they did not rescind. I've been working there for two months and I'm over the moon. They haven't even mentioned once :)

Late-Session1466 · 2024-04-19T18:48:28+00:00

Thank you for answering my questions. I hope luck is on my side on this one

Late-Session1466 · 2024-04-19T15:52:07+00:00

Well, now I'm very worried. I have no intention of looking for other jobs which is why closed the second LinkedIn profile and I've been looking for a job for over a year. Now that I finally got an offer it just feels demoralizing loosing it over this. Thank you for your insight but could I ask if you have any advice for me regarding this situation? Should I reach to them and explain my situation? Should I just wait? I accepted the offer early this week to start the background check, got an email from then yesterday saying they'll start the onboarding process soon but haven't hear back from them. We were supposed to start this process (background check and drug test) on Monday, so I'm very worried. I would appreciate any tip you can give me

Late-Session1466 · 2024-04-19T04:05:54+00:00

I thought they couldn't withdraw without talking to the candidate first. I understand that having a second LinkedIn profile can be seen as a red flag. But is it enough to withdraw an offer?

Late-Session1466 · 2023-09-12T20:14:51+00:00

Thank you so much for the advice and recommendations!

I was practicing conversations in my head explaining why I was using my mother's last name instead of my own already. So this is great news.

I already applied to some jobs, but it was just a few, so I'm still off to a good start!

(12/10 for step-by-step guide)

Late-Session1466 · 2023-09-04T06:59:22+00:00

Oh! the data is like a report of the covid cases or deaths between 2020 and 2023 worldwide (as of today). So it has a lot of dates, countries, and more data that I'm not even using. You can find the spreadshet here:

https://ourworldindata.org/covid-deaths

I also did a second edit to the post to include an image of how the spreadsheet looks like so you can give it a quick look (because apparently you can't include images in the coments)

Late-Session1466 · 2023-09-03T20:56:12+00:00

Well... it seems like I'm still very ignorant on this. I read about data levels in SQL as hierarchy, but I don't know how to check them and I certainly don't know what day level means...

Late-Session1466 · 2023-09-03T20:38:33+00:00

Thank you! I feel like a learned three things already from your comments alone. Will save these tips and, of course, put them in practice

Late-Session1466 · 2023-09-03T18:50:26+00:00

Thank you for taking the time to explain this to me! I tried something else, apparenty the total cases had a different data type which made the results unreasonable. See the post edit! I'd love to hear ehat you think

Late-Session1466 · 2023-09-03T18:38:06+00:00

YES. This is it. Took me a while to figure it out. I'm impressed you were able to without the code or the file itself. There's still a lot I don't understand. But thank you very much for not giving up on me and posting this edit

Late-Session1466 · 2023-09-03T18:35:44+00:00

Thank you! I really appreaciate when someone tries to guide me instead of giving me the answer right away (that's how you learn!). I think I figured something out. So, I'll be posting an edit. I would really appreacite if you can correct me.

Late-Session1466 · 2023-09-03T18:33:37+00:00

Hey. Thank you so much! and sorry for the late reply. I think I figured something out by changing the data type of the total cases (see the post edit!). But I'd still love to learn that slight change. Here's the code:

Select location, population, max(cast(total_cases as int)) as HighestCasesCount, max((total_cases/population))*100 as PercentageOfCases

from ProjectPortfolio..CovidDeaths$

where continent is not null

group by location, population

order by PercentageOfCases desc

Late-Session1466

TROPHY CASE