September 16, 2016 at 11:22 am
Jacob Wilkins (9/16/2016)
Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
ThomasRushton (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀
What about setting it up as one of the QotDs?
"You must answer this question to proceed..."?
Apart from an attempt to make me feel stupid everyday, what happens on the weekends (or when Steve runs out of question ideas :P)?
I was thinking more of a single QotD that all new users would be directed to. Think of it as a gateway question - one query to rule them all, or something...
Question: "Are you a spammer? (select valid query)"
Answer A: "SELECT 'Yes'"
Answer B: "SELECT 'No'"
Maybe even that would be too difficult for some.
How about something elementary like
"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"
Options:
1) 1024
2) 1729
3) 2048
4) 36
5) 35
I think I just got kicked off the forums. Either this is not expressed clearly or I am entirely too clueless because any answer by me on this would be a total shot in the dark.
Elementary my dear Sean,
1729 = 1^3 + 12^3
1729 = 9^3 + 10^3
😎
I figured you meant something along those lines but since I didn't know the answer I have no idea how I would go about solving it. :w00t:
As worded, the correct answer is actually 91 (missing the usual restriction to cubes of positive integers) 🙂
Cheers!
Err, no it's not.
-1729 = 12^3 + -1^3 = -10^3 + -9^3
and -1729 is smaller than 91 (for example – there are others even smaller)
So the question should ask for the smallest positive number ...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
September 16, 2016 at 11:25 am
Phil Parkin (9/16/2016)
Jacob Wilkins (9/16/2016)
Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
ThomasRushton (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀
What about setting it up as one of the QotDs?
"You must answer this question to proceed..."?
Apart from an attempt to make me feel stupid everyday, what happens on the weekends (or when Steve runs out of question ideas :P)?
I was thinking more of a single QotD that all new users would be directed to. Think of it as a gateway question - one query to rule them all, or something...
Question: "Are you a spammer? (select valid query)"
Answer A: "SELECT 'Yes'"
Answer B: "SELECT 'No'"
Maybe even that would be too difficult for some.
How about something elementary like
"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"
Options:
1) 1024
2) 1729
3) 2048
4) 36
5) 35
I think I just got kicked off the forums. Either this is not expressed clearly or I am entirely too clueless because any answer by me on this would be a total shot in the dark.
Elementary my dear Sean,
1729 = 1^3 + 12^3
1729 = 9^3 + 10^3
😎
I figured you meant something along those lines but since I didn't know the answer I have no idea how I would go about solving it. :w00t:
As worded, the correct answer is actually 91 (missing the usual restriction to cubes of positive integers) 🙂
Cheers!
Err, no it's not.
-1729 = 12^3 + -1^3 = -10^3 + -9^3
and -1729 is smaller than 91 (for example – there are others even smaller)
So the question should ask for the smallest positive number ...
Fair enough. 🙂 I suppose if I'm going to be picky I should be more careful. Although, the same applies to yours. 12^3+ -1^3 is not -1729 😛
Cheers!
September 16, 2016 at 11:30 am
...Although, the same applies to yours. 12^3+ -1^3 is not -1729
Cheers!
You got me. I feel a Jack Bauer "DAMN IT!" coming on 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
September 16, 2016 at 11:59 am
Hugo Kornelis (9/15/2016)
Anyone here planning to (or thinking about) going to Live! 360 Orlando?As a speaker, I have been given a special registration code that triggers a cheaper price $500 off the standard registration price (or $100 off the current Super Early Bird price).
See my blog if you want to know more, or register diectly using this link (with the code pre-populated).
I wish I could afford this or PASS or both.
September 16, 2016 at 12:19 pm
Steve Jones - SSC Editor (9/16/2016)
rodjkidd (9/16/2016)
Steve Jones - SSC Editor (9/15/2016)
Hugo Kornelis (9/15/2016)
Anyone here planning to (or thinking about) going to Live! 360 Orlando?As a speaker, I have been given a special registration code that triggers a cheaper price $500 off the standard registration price (or $100 off the current Super Early Bird price).
See my blog if you want to know more, or register diectly using this link (with the code pre-populated).
I'll see you there. I was sure that I hadn't submitted, but somehow I'm on the schedule.
And that that right there Steve, is proof that you have done too much this year and need a break 😉
Rodders...
You are correct. I have two open calls for 2017 that I've decided to pass on because I don't want to travel this much next year.
And here I was hoping to be able to talk you into coming to SQL Saturday Detroit in early 2017...assuming it happens.
September 16, 2016 at 1:41 pm
Phil Parkin (9/16/2016)
Jacob Wilkins (9/16/2016)
Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
ThomasRushton (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀
What about setting it up as one of the QotDs?
"You must answer this question to proceed..."?
Apart from an attempt to make me feel stupid everyday, what happens on the weekends (or when Steve runs out of question ideas :P)?
I was thinking more of a single QotD that all new users would be directed to. Think of it as a gateway question - one query to rule them all, or something...
Question: "Are you a spammer? (select valid query)"
Answer A: "SELECT 'Yes'"
Answer B: "SELECT 'No'"
Maybe even that would be too difficult for some.
How about something elementary like
"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"
Options:
1) 1024
2) 1729
3) 2048
4) 36
5) 35
I think I just got kicked off the forums. Either this is not expressed clearly or I am entirely too clueless because any answer by me on this would be a total shot in the dark.
Elementary my dear Sean,
1729 = 1^3 + 12^3
1729 = 9^3 + 10^3
😎
I figured you meant something along those lines but since I didn't know the answer I have no idea how I would go about solving it. :w00t:
As worded, the correct answer is actually 91 (missing the usual restriction to cubes of positive integers) 🙂
Cheers!
Err, no it's not.
-1729 = 12^3 + -1^3 = -10^3 + -9^3
and -1729 is smaller than 91 (for example – there are others even smaller)
So the question should ask for the smallest positive number ...
Now where shall I start? For a southpaw, obviously it would be the highest number... and mixing signs is more like going into a night club in Brighton, you never know what you're gonna get:hehe:
😎
September 16, 2016 at 1:52 pm
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
Heh... according to my interview question experiences, that would eliminate 90%.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2016 at 3:28 pm
I know we complain about the questions (a lot it seems) at times. And I am just as guilty of this next statement at times, but we really need to make a better effort at reading some the OPs responses before responding because the result could be offering a solution in search of problem (i.e. doesn't help).
September 16, 2016 at 3:37 pm
Ed Wagner (9/16/2016)
And here I was hoping to be able to talk you into coming to SQL Saturday Detroit in early 2017...assuming it happens.
You might be able to. I'm looking at 2017, but planning carefully.
September 16, 2016 at 9:25 pm
Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
ThomasRushton (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀
What about setting it up as one of the QotDs?
"You must answer this question to proceed..."?
Apart from an attempt to make me feel stupid everyday, what happens on the weekends (or when Steve runs out of question ideas :P)?
I was thinking more of a single QotD that all new users would be directed to. Think of it as a gateway question - one query to rule them all, or something...
Question: "Are you a spammer? (select valid query)"
Answer A: "SELECT 'Yes'"
Answer B: "SELECT 'No'"
Maybe even that would be too difficult for some.
How about something elementary like
"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"
Options:
1) 1024
2) 1729
3) 2048
4) 36
5) 35
I think I just got kicked off the forums. Either this is not expressed clearly or I am entirely too clueless because any answer by me on this would be a total shot in the dark.
This is a badly expressed schoolboy arithmetic question which is not answerable without clarification of what the question is supposed to mean. I guess it was taken from some work of fiction, because I can't imagine anyone putting it in a textbook without making the requirement clearer.
Of course having said that I now have to explain why; but when reading the explanation which follows don't forget take a pinch or two of salt with it.
The obvious answer to that question is to ask four questions that have to be answered before you can think of answering this question, as its meaning is not at all clear. Or maybe the answer is "I suppose you intended to ask for 1729, but I don't much like the way you formulated the question".
"what do you mean by different?" and
"what do you mean by number?" and
"what do you mean by cube?" and
"what do you mean by smallest?".
The usual meaning of "the smallest number with some property" is that you can consider all numbers with the required property and select the smallest; but perhaps the intention was to restrict the numbers to be considered to the numbers on the list? If that restriction was intended, "the smallest number" should have been "the smallest of these numbers" of something like that to make the meaning clear. If it wasn't intended, the list should have a "none of these" option.
Perhaps the requirement to be "different" is intended to mean that A+B and B+A count as only one way of expressing something? Or perhaps not: that A+B and B+A are the same expression as opposed to two distinct expressions which denote the same value is a rather bizarre position to take.
What is a cube? Is it the cube of an integer, so that some cubes are negative? Or the cube of a nonnegative integer, so that 0 is a cube, or is it the cube of an integer greater than 0? And what is a number? Is it any integer? or a non-negative integer? Or a nonzero positive integer?
If "number" means "number" in the list, maybe the answer is 35 as that can be written as 27+8 or as 8+27. Without that meaning, none of the numbers in the list is the right anwer unless all cubes are required to be positive non-zero; and if numbers can be any integers and cubes can be the cubes of any numbers the question is meaningless (since there is then no lower bound, neither to numbers nor to cubes). Even allowing 0 is dangerous, since then (for example) 1+0 and 0+1 are two ways of expressing the cube 1 as the sum of two cubes.
Perhaps doing a thorough job of answering 3 of the 4 questions would make the question unambiguous, but perhaps it wold be beter to answer all four just to be sure.
Tom
September 17, 2016 at 12:56 am
TomThomson (9/16/2016)
Sean Lange (9/16/2016)
Eirikur Eiriksson (9/16/2016)
ThomasRushton (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
Sean Lange (9/16/2016)
BWFC (9/16/2016)
jasona.work (9/16/2016)
Thom A (9/16/2016)
ThomasRushton (9/16/2016)
These posts offering ways to get rid of weight loss? What? Eat more SPAM. Eat more pies. Icecream. Cakes.All works for me... 😉
I never thought there'd be a day where I wished for a CAPTCHA field where there wasn't one 😛
Nah, the spammers have ways to beat CAPTCHA fields...
We need a SQL-specific method to weed out the spammers...
Something like this:
Write a SELECT query to join the following two tables, returning only data fields that exist in each
Table A
ID Data
1 A
2 B
4 D
Table B
PK Data
0 A
1 C
2 B
:hehe:
Or we could ask how to get the current time and date....
No that would eliminate entirely too many people that actually need help. 😀
What about setting it up as one of the QotDs?
"You must answer this question to proceed..."?
Apart from an attempt to make me feel stupid everyday, what happens on the weekends (or when Steve runs out of question ideas :P)?
I was thinking more of a single QotD that all new users would be directed to. Think of it as a gateway question - one query to rule them all, or something...
Question: "Are you a spammer? (select valid query)"
Answer A: "SELECT 'Yes'"
Answer B: "SELECT 'No'"
Maybe even that would be too difficult for some.
How about something elementary like
"Select the number which is the smallest number expressible as the sum of two cubes in two different ways"
Options:
1) 1024
2) 1729
3) 2048
4) 36
5) 35
I think I just got kicked off the forums. Either this is not expressed clearly or I am entirely too clueless because any answer by me on this would be a total shot in the dark.
This is a badly expressed schoolboy arithmetic question which is not answerable without clarification of what the question is supposed to mean. I guess it was taken from some work of fiction, because I can't imagine anyone putting it in a textbook without making the requirement clearer.
Of course having said that I now have to explain why; but when reading the explanation which follows don't forget take a pinch or two of salt with it.
The obvious answer to that question is to ask four questions that have to be answered before you can think of answering this question, as its meaning is not at all clear. Or maybe the answer is "I suppose you intended to ask for 1729, but I don't much like the way you formulated the question".
"what do you mean by different?" and
"what do you mean by number?" and
"what do you mean by cube?" and
"what do you mean by smallest?".
The usual meaning of "the smallest number with some property" is that you can consider all numbers with the required property and select the smallest; but perhaps the intention was to restrict the numbers to be considered to the numbers on the list? If that restriction was intended, "the smallest number" should have been "the smallest of these numbers" of something like that to make the meaning clear. If it wasn't intended, the list should have a "none of these" option.
Perhaps the requirement to be "different" is intended to mean that A+B and B+A count as only one way of expressing something? Or perhaps not: that A+B and B+A are the same expression as opposed to two distinct expressions which denote the same value is a rather bizarre position to take.
What is a cube? Is it the cube of an integer, so that some cubes are negative? Or the cube of a nonnegative integer, so that 0 is a cube, or is it the cube of an integer greater than 0? And what is a number? Is it any integer? or a non-negative integer? Or a nonzero positive integer?
If "number" means "number" in the list, maybe the answer is 35 as that can be written as 27+8 or as 8+27. Without that meaning, none of the numbers in the list is the right anwer unless all cubes are required to be positive non-zero; and if numbers can be any integers and cubes can be the cubes of any numbers the question is meaningless (since there is then no lower bound, neither to numbers nor to cubes). Even allowing 0 is dangerous, since then (for example) 1+0 and 0+1 are two ways of expressing the cube 1 as the sum of two cubes.
Perhaps doing a thorough job of answering 3 of the 4 questions would make the question unambiguous, but perhaps it wold be beter to answer all four just to be sure.
You are absolutely right Tom, the question was badly phrased. Probably better to ask for the smallest taxicab number or "smallest number that can be expressed as a sum of two positive algebraic cubes in 2 distinct ways" . The question comes from Srinivasa Ramanujan's reply to G. H. Hardy's comment on a dull number on a taxicab, hence the name taxicab number.
😎
September 17, 2016 at 7:56 am
This weekend is the Open House weekend in London, just wondering if SSC is participating in something similar like Open Spam:pinch:
😎
September 18, 2016 at 9:47 am
Now where is that crystal ball again?
😎
September 19, 2016 at 1:52 am
Eirikur Eiriksson (9/18/2016)
Now where is that crystal ball again?😎
You're going to need a pair of those. The OP (or should that be "perp"?) has been posting for over three years yet somehow avoided creating a single table in that time 🙂
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
September 19, 2016 at 3:37 am
Steve Jones - SSC Editor (9/16/2016)
Ed Wagner (9/16/2016)
And here I was hoping to be able to talk you into coming to SQL Saturday Detroit in early 2017...assuming it happens.You might be able to. I'm looking at 2017, but planning carefully.
Thanks. I know it's been talked about for a while now and still hasn't happened :crazy: yet, but at least it sounds hopeful this time.
Viewing 15 posts - 55,846 through 55,860 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply