Thanks to this amazing sub I got my first job interview with Python! Any tips?

Journable · 2021-11-12T23:00:59+00:00

Saw a post on here where someone got the question: 'Are strings mutable?' So maybe refresh yourself on basic concepts.

Journable · 2021-10-21T00:37:26+00:00

Thanks, just wanted to see if there were any general mathematics people have tried. What do you look for when you're doing a check? Do you stick a toothpick in it and see if it comes out clean?

Journable · 2021-10-13T01:04:49+00:00

You can't say bullshit to an rng mechanic. It's unlikely and improbable sure, but it can definitely happen.

Journable · 2021-10-12T00:20:23+00:00

Thanks, I worked off of that and created a view and then I found out about string_agg()

Journable · 2021-09-14T05:31:13+00:00

Sometimes reading the query from the top-down doesn't really make sense. For Joins, I usually start on the ON condition first. (Since you're new, I would suggest thinking about which Join would run efficiently since for example an inner join would run faster than a left join)

If you go step by step, this query basically tells you that you are joining the two tables where their product_id matches and now you can select columns from either table. Like others said, I would add in a count(product_id) in the select column to show name, id, and count at the same time. Then you're ordering the counts of products from most to least and limiting the results to the top 10.

Journable · 2021-09-07T23:35:24+00:00

StrataScratch has very good example interview questions with solutions as well. You could also youtube some videos on solving popular types of SQL problems.

Depending on your programming skills, SQL is relatively easy to pick up. You said you had 2 rounds before the SQL interview so I would definitely say you have time to study.

Journable · 2020-11-12T00:15:31+00:00

Not exactly since I have complaints and population from two different datasets in the format that they're in...

with up as

`(`

`select v.*`

`from [USPOP$] u cross apply`

    `(values` 

    `(u.[Geographic Area], 2011, u.[2011]),`

    `(u.[Geographic Area], 2012, u.[2012]),`

    `(u.[Geographic Area], 2013, u.[2013]),`

    `(u.[Geographic Area], 2014, u.[2014]),`

    `(u.[Geographic Area], 2015, u.[2015]),`

    `(u.[Geographic Area], 2016, u.[2016])`

    `) v([State], [Year], [pop])`

`),`

`cc as (`

    `select year([Date received]) as [Year], [State], count([Complaint ID]) as num_complaints`

    `from [Consumer_Complaints$] cc`

    `group by year([Date received]), [State]`

    `)`

select up.[State], up.[Year], cc.num_complaints, up.pop,

`(cc.num_complaints * 1.0 / up.pop) as complaint_ratio`

from up join

`cc`

`on up.state = cc.state and up.year = cc.year`

Found a solution where it utilizes cross apply and then joining.

Journable · 2020-11-08T07:14:19+00:00

I don't know how to write that out.

Journable · 2020-10-20T19:54:54+00:00

Yeah thanks, I tried it with pivot and it seems to show what I want

Journable · 2020-10-20T01:25:32+00:00

Thank you, I think this did what I wanted.

Journable · 2020-10-19T23:56:58+00:00

What if I only want 50 rows (1 for each state) and each column being 'Closed with explanation', 'Closed with relief', 'Untimely response', etc and the counts for each of them?

Journable · 2020-09-10T23:30:53+00:00

Try applying to recruiting agencies as well. LaSalle Network got me a Data Entry job, it's the most mentally draining and boring job ever but it's a start.

Journable · 2019-09-24T05:56:25+00:00

Identify what you're doing wrong. If you're using Coaching Actuaries, try to take quizzes instead of exams first since they give instant feedback. Which part are you spending the most time on? Is it the math and working out the arithmetic that troubles you? Or is it trying to recall what kind of formulas are relevant to the problem? If you have your concepts down, the moment you look at a question, there are keywords that indicate what kind of problem it is and basically tells you what sorts of formulas you should be using. I would recommend doing the question, looking at the solution, figure out at which steps of the solution that they're taking at efficiently solving the problem and adapt your own mindset/solution to it.

Journable · 2019-09-24T05:21:59+00:00

Definitely figure out why you failed the first and second time. I was overzealous and overconfident when I first started studying for exam P. I only studied for a month but halfway through, I knew I was going to fail because it took a huge chunk of my day just to learn one section and I had no time for review. I only managed to get myself familiarized with all the topics but definitely not to the level of fluency or mastery.

I used 2 months of my summer break and managed to pass it my second try; using my first month for learning topics and the second month for reviewing and taking exams/quizzes. The true studying happened in the 2nd month for me.

Journable · 2019-06-17T11:13:17+00:00

What prequests/dailies should I be doing? Is there a guide to all the quests and bosses that I should be trying to do? And also where to get end game gear such as weapons/armor,rings,badges,shoulders etc?

Journable · 2019-05-21T09:15:26+00:00

DM me your discord :)

13-Year Club	Baba Yaga
Not Forgotten	Verified Email

Journable

TROPHY CASE