DavidSzczesniak
1/18/2018 - 4:15 PM

MIN AND MAX

\!h Basic example:
SELECT MAX(artist) FROM artist; -- same goes for the minimum using MIN

\!h More specifc example:
SELECT MAX(downloads) FROM fake_apps; -- highest value of downloads from fake_apps table
-- meaning the most popular app has x amount of downloads

\!h Set of input, multiple values:
MAX(n1, n2, n3...) -- returns greatest value in set
MIN(n1, n2, n3...) -- returns smallest value in set