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?