User contributions for Taichikitty
Jump to navigation
Jump to search
31 March 2013
- 20:4020:40, 31 March 2013 diff hist +9 Self join As stated, Question 7 result should only give one line for each unique pair of company, num; thus added DISTINCT.
23 March 2013
- 18:3118:31, 23 March 2013 diff hist −5 SELECT within SELECT Tutorial MAX on gdp is unnecessary when using ALL in this case. Both work, and MAX is cleaner, but this example is supposed to be all about the ALL.
19 March 2013
- 23:0523:05, 19 March 2013 diff hist −1 SELECT within SELECT Tutorial Changed question text ( removed a '0' ) quantity to match quantity in answer SQL. I am starting to suspect someone is subtly corrupting this page.
- 17:1217:12, 19 March 2013 diff hist −51 SELECT within SELECT Tutorial Question 6 asks for area, but the answer SQL was the same as the example, and gave country with greatest population. I tweaked the question text to ask for continent, name, and area. I changed the answer SQL to check for greatest area.