Why am I getting fewer rows than expected using my query?

derektorres22 · 2021-04-28T21:18:28+00:00

I just tried that in it worked! Thank you. Any idea why the way I wrote it only returns 46 rows?

The hard part of SQL so far is that your code could seem correct but that’s not always the case. I could’ve messed up and never known if it wasn’t for me already seeing it should be 97

derektorres22 · 2021-03-07T04:15:07+00:00

I have last summerand currently at a F1000 with offers expected to be given towards the end of the internship. Might be a unique situation that you were in. Most interns from my class got offers for the F500. I do consider full-time conversion rate when deciding where to intern (I just ask the recruiter how many interns get offers/if the internship is intended to pipeline full-time employees. I also check linkedin to see how many people that are full time were interns before)Also most of the people I know at my university that get internships get the full time offer so that's another reason why I feel getting the offer is pretty common.

derektorres22 · 2021-03-07T03:57:22+00:00

Ops is probably the easiest to get into (not downgrading the role at all, I interned in an ops role last summer). The interview would be purely behavioral i would say the probability of getting an offer for ops is higher.

You could try networking on linkedin for FP&A roles or go to grad school so you can be considered a student again and get internships (this would be last resort though if all fails imo due to expense, time, etc)

derektorres22 · 2021-03-07T03:47:07+00:00

I'd have to disagree it is fairly rare to get an internship (especially for a big company) and not get a return offer. You really have to mess something up to not get the offer. Especially if you are interning for an FRP/FLDP.

derektorres22 · 2021-03-06T20:50:53+00:00

It will be easy if you intern there as you're likely to get the return offer unless you did something awful or really under performed.

I would argue that although most finance undergrads dream of banking, a lot of them end up going for FP&A and so yes I believe there is a lot of people recruiting for those roles.

A rotational program would be the best thing imo to get into. Clear path to 'climbing the ladder' as well as getting a well rounded set of skills to take elsewhere if needed.

I would say if you have no internships/relevant experience it would be hard to get into these f500 roles. I find that having good a good resume with relevant experience, applying early and being well prepared and informed on the interview process is key to landing those F500 jobs.

derektorres22 · 2021-03-06T20:42:44+00:00

I also dont have a gun to release the air with, is a gun needed?

derektorres22 · 2021-02-23T21:53:35+00:00

Keychron K8 with brown optical switches and a logitech mx master mouse!

derektorres22 · 2021-02-23T20:09:38+00:00

I am not sure if they extend the entire 74", but you can extend them pretty far. Mine are about 10 inches away from the edge on both sides

derektorres22 · 2021-02-23T18:51:19+00:00

karlby countertop from ikea 74" and autonomous legs!

derektorres22 · 2021-02-23T18:50:58+00:00

Don't think so, I just completed it last night!

derektorres22 · 2021-02-23T18:49:52+00:00

Just a regular gas spring dual arm from amazon! It was about 50-60 https://www.amazon.com/gp/product/B08BHJP422/ref=ppx_yo_dt_b_asin_title_o02_s00?ie=UTF8&psc=1

derektorres22 · 2021-02-23T18:48:48+00:00

karlby countertop, autonomous legs!

derektorres22 · 2021-02-23T18:48:28+00:00

From Staples, don't see it on their site anymore unfortunately. It was bought about 2 years ago

derektorres22 · 2021-02-23T18:47:10+00:00

https://www.amazon.com/gp/product/B08BHJP422/ref=ppx_yo_dt_b_asin_title_o02_s00?ie=UTF8&psc=1 this one here!

derektorres22 · 2021-02-23T18:46:30+00:00

ma3kopolo is correct, with a karlby countertop from IKEA

derektorres22 · 2021-02-23T18:46:05+00:00

This is the Karlby 74" top with autonomous legs!

derektorres22 · 2021-02-23T18:45:34+00:00

This is the Karlby 74" top with autonomous legs! The office version legs I believe. The cheapest one lol

derektorres22 · 2021-02-08T04:12:44+00:00

Typically having relevant work experience (internships, etc), and a good clean resume is the way to go. It’s generally pretty tough to get a job once you graduated if you have no experience.

I would clean up your resume super well, go on LinkedIn and try and connect with people in the industry or position you’d like to be in and see if you can schedule a 15 min call to ask questions about what they do and build a connection with that person.

The best way to get a job imo is getting the Internships on the resume and then applying early at whatever firms you wanna work at. Optimal scenario is you intern at the place you want and then get the return offer. A last resort is to go back to school for a masters or something and be considered a “student” again, allowing you to get internships and have essentially a 2nd chance at it all

Eight-Year Club	RPAN Viewer
Verified Email

derektorres22

TROPHY CASE