thanks all

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #401,258 by crazy 4/27/15 9:59:07 PM Reply	thanks all I was really over thinking it. Allocate 100 minutes for test. 3 problems. 1st: given standard emp/dept, total sum of salary by department. 1 minute. 2nd: emp/dept again, gimme count of people by department. 1 minute. 3rd: given series of measurements, show the most recent measurement for each sensor. Problem wanted a correlated subquery, but the time stamps were unique, so I didn't need to match on multiple fields, and could use an simple min(time) feeding an "in" clause. 3 minutes. Next interview (group attack) being set up.
Post #401,260 by Another Scott 4/27/15 11:25:22 PM Reply	Woot! Excellent. Best of luck with the next hurdles.
Post #401,283 by crazy 4/28/15 5:36:35 PM Reply	face to face setup In NYC, 3 minute walk from my last job. But they prefer I work from home and simply visit the office occasionally.
Post #401,288 by a6l6e6x 4/29/15 9:10:11 AM Reply	Re: they prefer I work from home "Please don't throw me in that briar patch!" :) Alex "There is a cult of ignorance in the United States, and there has always been. The strain of anti-intellectualism has been a constant thread winding its way through our political and cultural life, nurtured by the false notion that democracy means that "my ignorance is just as good as your knowledge." -- Isaac Asimov
Post #401,317 by crazy 4/29/15 5:38:01 PM Reply	actually, I prefer going in As long I can control my light and noise. There is way too much opportunity for missed communications and people don't realize how much they lose by not having face to face meetings.
Post #401,326 by a6l6e6x 4/29/15 8:47:41 PM Reply	That depends what you're doing at the time. When you have a well known objective and a lot of code to produce solitude can be a boon. But yeh, when you the objective is a bit fuzzy and needs to be clarified with others then you need to be there. Same when you need feedback on what you've done so far. Alex "There is a cult of ignorance in the United States, and there has always been. The strain of anti-intellectualism has been a constant thread winding its way through our political and cultural life, nurtured by the false notion that democracy means that "my ignorance is just as good as your knowledge." -- Isaac Asimov
Post #401,263 by drook 4/28/15 1:00:01 AM Reply	Did they think it would take that long? -- Drew
Post #401,282 by crazy 4/28/15 5:33:54 PM Reply	don't think so These were essentially the starting queries I'd use to winnow job applicants who claimed to know SQL, and I've seen some horrendous attempts that would take 15 minutes to code that would never run.
Post #401,284 by drook 4/28/15 5:55:48 PM Reply	Yeah, they're good screeners -- Drew

need a SQL refresher - (crazy) - (15) - April 18, 2015, 10:27:09 AM EDT

This seems to be a decent list. - (Another Scott) - April 18, 2015, 11:27:27 AM EDT

Questions 1 - 10 from the one I had to take last week - (lincoln) - April 18, 2015, 04:47:43 PM EDT

Questions 11 - 20 from the one I had to take last week - (lincoln) - April 18, 2015, 04:51:03 PM EDT

Questions 21 - 29 from the one I had to take last week - (lincoln) - April 18, 2015, 04:56:08 PM EDT

Questions 30 - 36 from the one I had to take last week - (lincoln) - April 18, 2015, 04:58:32 PM EDT

Here's another one - (lincoln) - April 21, 2015, 12:19:17 PM EDT

thanks all - (crazy) - (8) - April 27, 2015, 09:59:07 PM EDT

Woot! Excellent. Best of luck with the next hurdles. -NT - (Another Scott) - (4) - April 27, 2015, 11:25:22 PM EDT

face to face setup - (crazy) - (3) - April 28, 2015, 05:36:35 PM EDT

Re: they prefer I work from home - (a6l6e6x) - (2) - April 29, 2015, 09:10:11 AM EDT

actually, I prefer going in - (crazy) - (1) - April 29, 2015, 05:38:01 PM EDT

That depends what you're doing at the time. - (a6l6e6x) - April 29, 2015, 08:47:41 PM EDT

Did *they* think it would take that long? -NT - (drook) - (2) - April 28, 2015, 01:00:01 AM EDT

don't think so - (crazy) - (1) - April 28, 2015, 05:33:54 PM EDT

Yeah, they're good screeners -NT - (drook) - April 28, 2015, 05:55:48 PM EDT

iwethey.org

So let me sign off in idiocy...
151 ms