6. numbers II

Get Help SQL
#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.

1 Like
#4

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