Christmas 2017 - Part 4
-
Comments posted to this topic are about the item Christmas 2017 - Part 4
-
Cheers Steve but a bit of a typo in this one too, cut and paste have a lot to answer for!!
...
-
Very hard to know if 'Adult' refers to the Age or Genre for the movie "'s a wonderful life"...
Just because you're right doesn't mean everybody else is wrong. -
Hi Steve,
In the 4th row number of values is incorrect as there are only 4 values in it and there are 5 values in other rows. So we got the following error message:
Msg 10709, Level 16, State 1, Line 8
The number of columns for each row in a table value constructor must be the same.
If we insert an additional value (an arbitrary one) after 'George Bailey' then the query will produce the 'George Bailey' as a result in both cases if we order by genre or age.
See the attached screens:
So I think the "genre" is also a correct solution. - sandor.reti - Thursday, December 28, 2017 2:58 AMHi Steve,
In the 4th row number of values is incorrect as there are only 4 values in it and there are 5 values in other rows. So we got the following error message:
Msg 10709, Level 16, State 1, Line 8
The number of columns for each row in a table value constructor must be the same.
If we insert an additional value (an arbitrary one) after 'George Bailey' then the query will produce the 'George Bailey' as a result in both cases if we order by genre or age.
See the attached screens:
So I think the "genre" is also a correct solution.I think if you use the corrected line for QOTD Part 3 the solution works out correct, I believe this is the same error as the previous question; the genre would then be "Classic" and not "Adult". Steve?
...
-
'''s broken again
- Rune Bivrin - Thursday, December 28, 2017 12:30 AM
Adult is an age and not a Genre. Although, some might argue that Adult is a genre, but it's definitively not the genre for It's a Wonderful Life.
This is what I did to correct the data set.
SELECT *
FROM
( VALUES ('Ebenezer Scrooge', 'A Christmas Carol', 'Old', 'Fiction', 'London'),
('Dumbledore', 'Harry Potter and the Sorcerer''s Stone', 'Very Old', 'Fantasy', 'Hogwarts'),
('Frosty', 'Frosty The Snowman', 'Infant', 'Animated', 'A small town'),
('George Bailey', 'It''s a Wonderful Life', 'Adult', 'Drama', 'Falls')
) AS a (SomeName, Movie, Age, Genre, Locale) -
Well, I thought I corrected this yesterday. Apparently I must not have saved the changes. Code should be:
SELECT TOP 1
answer = SomeName
FROM
( VALUES ('Ebenezer Scrooge', 'A Christmas Carol', 'Old', 'Fiction', 'London'),
('Dumbledore', 'Harry Potter and the Sorcerer''s Stone', 'Very Old', 'Fantasy', 'Hogwarts'),
('Frosty', 'Frosty The Snowman', 'Infant', 'Animated', 'A small town'),
('George Bailey', 'It''s a Wonderful Life', 'Adult', 'Classic', 'Bedford Falls')
) AS a (SomeName, Movie, Age, Genre, Locale)
ORDER BY
-
Don't worry, Steve. As it was before the correction was good enough to figure out the correct answer. Thanks for the question!
- Revenant - Thursday, December 28, 2017 12:36 PM
Cheers
-
Nice one, thanks Steve (Glad i got to answer this after corrections applied)...
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply