andy_boot

8 ms·

31.
by andy_boot 9y ago
True. Well observed. How would you resolve this?
32.
by andy_boot 9y ago
Despite being the author I think you are correct. It should be table: 'cat' not 'cats'
33.
by andy_boot 9y ago
1) Yes. I'll re-word that part. 2) I debated with myself on that. On one hand it is clearly better to ORDER BY. On the other hand I'm trying to teach people the window functions and I don't want them typing in more SQL than
34.
by andy_boot 9y ago
you are correct. I'll fix that.
35.
by andy_boot 9y ago
That query looks fine to me, I'll tweak the code. Yep I need to fix up Q10 a bit.
36.
by andy_boot 9y ago
good idea. I'll fix that.
37.
by andy_boot 9y ago
Author here - I'm scrolling thru the logs and it is interesting to see that on the first question lots of people try to write "select name, total_weight" despite there only being a weight column which you have to use an aggre
38.
by andy_boot 9y ago
Good find. Thank you.
39.
by andy_boot 9y ago
Author here. - As others have said this SQL Engine makes me write the SQL out the long way. For some reason the shorter version (which I wrote first) is rejected by my postgres client.
40.
Advanced SQL window function quiz(windowfunctions.com)
163 points by andy_boot 9y ago|79 comments
41.
by andy_boot 9y ago
True But I would like to show you an interesting counterexample which requires changing the rules slightly. If we toss a coin and keep tossing until one of the below sequences turn up then which sequence is more likely? HHHHHH THHHHH Answ
42.
by andy_boot 9y ago
>But lets say they go bankrupt in 1 year, couldn't they just switch to "profit mode"? Well that they might have to try and do now. But usually it is hard to move to 'profit mode' - you upset your customers when y
43.
by andy_boot 9y ago
While crude, I do think raverbashing has a point here. If a 10 person startup already requires their devs to use 3 different reporting tools that startup has a problem. If you can't streamline at a small size like this you won't s
44.
by andy_boot 9y ago
and the reference will tell them to get stuffed. Leaking salary details of employees to a competitor will get you fired.
45.
by andy_boot 10y ago
It is true that milk is a good source of vitamin D and calcium. It helps prevent things like Rickets which was why it was mandatory in schools when I was young. It is also one of the few non-sugary examples of a kids drink so I'm quite
46.
by andy_boot 10y ago
The EU is a large multi country bureaucracy - they need time to consider things like this and I expect they have bigger problems to worry about. Basically don't expect an organisation that large to jump up the same day a solo develope
47.
by andy_boot 10y ago
I don't think it will happen that way. It's as easy to live in a regular van as a self driving van. Sure some people do it but not many. I imagine that far less people will own cars and instead there will be a fleet of self drivin
48.
by andy_boot 10y ago
I don't understand the downvotes here. I work in a London startup where about 90% or our engineers are not British. They tell me that they are already seeing adverts saying 'move to berlin/dublin' on their facebook feed.
49.
by andy_boot 10y ago
It is definitely going to be a problem. And people are already pushing see: Truck Drives Around London Urging Move To Berlin: http://www.lbc.co.uk/truck-drives-around-london-urging-move-...
50.
by andy_boot 10y ago
I actually think that's a better way to do it than what we usually have to go through. I believe the Israel uses this technique as well.
51.
by andy_boot 10y ago
I like this idea but I know that I have accidentally entered my password or my password with a typo in it on the terminal on at least one occasion. The only way round this that I can see is to grep out the password - but then my password (o
52.
by andy_boot 10y ago
>Oh come on. Did the regulation in the financial system protect "the customer" Yes it did. Nobody lost money in their savings or current accounts in commercial banks (Except Iceland) What happened in the stock market was diffe
53.
by andy_boot 10y ago
I was surprised by that statement too, I don't think it is true in London.
54.
by andy_boot 10y ago
I met him once back then I didn't know who he was. Weirdly I was reading the book: http://www.codersatwork.com/ at the time - ofcourse I got a shock when I realised he was the next chapter! Anyway he was a nice guy.
55.
by andy_boot 11y ago
Got to disagree here. Even if your task takes only 30 minutes, by the time you add getting client's requirements and browsing for jobs each task will take 1 hour. You should not be working for $5 / hour.
56.
by andy_boot 11y ago
Similar story here. Raised in the Midlands, studied in the Midlands, work in London. Why do I work in London? Because that's where all the jobs are. My thoughts went something like this: Where are the high paying jobs? Finance -> Go
57.
by andy_boot 11y ago
I'm fairly sure if you just park your car in front of the truck on a remote highway the drive safety systems will kick in and stop the truck. Then you jump out and crowbar/bolt-cutter the container. Of-course it will probably dete
58.
by andy_boot 11y ago
Sounds like Asmiov's "The Strips"
59.
by andy_boot 11y ago
If they are making a loss this implies they are not paying dividends. Therefore how can PE ratio be positive ?
60.
by andy_boot 11y ago
I recall a story of a company that was analysing student loans, finding people most likely to pay the loan off and buying that debt. So yes I expect there are already student credit default swaps somewhere.

More ›