A couple more useful numeric SQL functions are included below:
MAX(n1,n2,n3,...): returns the greatest value in the set of the input numeric expressions
MIN(n1,n2,n3,...): returns the least value in the set of the input numeric expressions
baked_goods table, in addition to the numeric
ingredients_cost we have information about the packaging cost located in the
packaging_cost column. We can use the
MAX function to determine the overall greatest value of cost for each item using the following query:
SELECT id, MAX(ingredients_cost, packaging_cost) FROM baked_goods;
We also have information about cook time designated as
cook_time and cool down time designated as
cool_down_time in the
baked_goods table. Find the greatest time value for each item in the table.
Find the least time value for each item in the table.