Hey everyone, using SQL does anyone know how you can sum the top N records and return one output? Is a RANK function needed? For example top 10 items with sales all summed to return one value.

I have interview scheduled for senior software engineer role(exp- ~8years) at cisco. What should I expect in the interview, dsa algo is also asked, how many rounds?
skill - java, aws, microservices

Paralegals: what’s your least favorite thing about working with attorneys?

What is the Apta test in hsbc ? How difficult it is?

Best Mens white formal and informal slim fit shirts?

Does anyone know how to make their resume look more manager like? My resume shows:

- I have the skills and experience.
- I tailored it to the job description

The recruiter at a job fair yesterday said I'm a good fit, but to send her an email with edits to the resume to make it look more like a managers one because they have to sell applicants to higher ups and schedule an interview.

I can't wait too long to send it, so nervous as I'm picking at it trying to further change it.

Can anyone help me wrap my head around this post Series C start-up equity offer? It’s an IP director position, the the base is $170 with 10% bonus (both lower than I was expecting). There’s also an equity component: 0.15% of current fully diluted equity. This equates to about 30000 shares at a strike price of $2. They also indicate the preferred stock price is $6 and preferred stock equity is $188k (whatever that means). They are in the middle of a new financing and valuation round.

Any suggestions on good books on consulting for reading during holidays

Anyone in GT Accounting Advisory? What's the day to day like and how is the WLB?

Should I or should I not send a quick email re good news of passing the bar to my small (<10p) practice group team?

How much support staff is reasonable to expect? Plaintiff PI, med mal/aviation and we’ve lost 2/4 “paralegals” in the last month. Lack of support staff really beginning to feel like it will limit my ability to handle the usual caseload. Was on an island before, and only going to get worse…

Does anyone mind looking over my resume and giving some feedback?

Anyone here work in law in Miami (ideally - media, entertainment or IP practice)?

Hi Fishes,

Any opening in cyber security domain.
Yoe - 6
Skill set - risk assessment, cloud security, Vapt , threat modelling

Pls give some lead. Thanks in advance

Anyone else hearing from multiple WOC who had their Times Up RSVPs cancelled after the fact?

I'm new to marketing and I am not formally educated in it. I have just been learning through experience with the business. I'm supposed to put together a Market report for our sales team to refer to but I have been stuck on what I even include. I have an expensive subscription to a reporting database and I am supposed to translate these technical reports into 20-30 slides. I can't figure out if I am overthinking something simple or lacking some knowledge that people formally learn in school.

Folks can someone share recommendations for a trusted movers and packers to move from Chicago to Bay Area?

Hi! I have been seriously applying for weeks upon weeks for a scrum master position/agile coach. But it’s hard getting an offer 😢

Anyone has IBS here? Lately I have been having a lot of symptoms of IBS and even if I’m not fully constipated, I think I am to a certain extent. I had excruciating lower abdominal pain this afternoon and it was almost unbearable. Also, my period is approaching so I think my symptoms got worse. Anyone has any tips?

Has anyone made the jump to Altman Vilandrie & Co? Seems like a really cool space with interesting work

Does anyone know where I can get salary range demographic data? Thank you.

Using declare, set function in SQL and in my declare function I am returning the following error:
“Cannot coerce expression (SELECT SUM(…”

Can’t find anywhere as to what this error means.

Although when I run the set query by itself, the sql does run correctly. But the error seems to occur when I add the SET function and using an open and close parenthesis around the query I am setting my
Variable to. Any idea as to what is causing this error?

Want to re start my carrier as a data analyst in any good corporate after six years, is it possible?

Are there any data science certifications that people can recommend which will be well received/recognized on resumes? Thanks in advance!

Hello! I hope you had a great thanksgiving! For those that have pivoted into the technology field, how did you start? To be more specific I’m looking to pivot from higher education to data analytics and would like to know how to go about that. Are their particular certificates I need to get? Any direction would be appreciated. Thank you

Has anyone used the website DataCamp? I’ve been using it to learn Data Science because my work provides free access and have been enjoying it. Anyone else have experiences with DataCamp? I’ve have been working through the “Python for Data Science” course.

Is anyone hiring? I need a new job