6. numbers II


#1

Hi i just wanna know how does the code work?
does it pick the maximum value from both columns?

https://www.codecademy.com/courses/sql-table-transformation/lessons/date-number-string-functions/exercises/numbers-ii?action=lesson_resume

SELECT id, MAX(ingredients_cost, packaging_cost)
FROM baked_goods;

thank you


#2

It picks the maximum value of the two columns with ID.


#3

Ok I got it. Thanks a lot.


#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.