<PLEASE USE THIS TEMPLATE TO HELP YOU CREATE A GREAT POST!>
<Below this line, add a link to the EXACT exercise that you are stuck at.>
<Below this line, in what way does your code behave incorrectly? Include ALL error messages.>
Hi all, this is the first time that I post for help on the forum, if there is anything inappropriate, please excuse me.
SELECT id, cook_time, cool_down_time FROM baked_goods;
we’ll get the query results as shown below:
But the results of
SELECT id, MAX(cook_time, cool_down_time) FROM baked_goods;
which made me extremely confused, because I think the MAX and MIN functions are supposed to return the greatest and least value respectively.
In the row where id = 2, the 33 of cool_down_time is larger than the 5 of cook_time obviously, but why the result returns as 5? The same circumstance occur in the rows where id = 13 and 15.
Could anyone explain it for me, please?
<In this course, it often helps to include a screenshot of your whole web browser – that lets everyone see what you see. If you wish to include a screenshot, add it below this line.>
<If you wish to copy/paste in your code, you can use this next section. This will allow others to copy/paste your code for testing – something that they won’t be able to do with just a screenshot.>