ORDER BY ORDER BY 'COLUMN' ASC - default, DESC using index number instead of column names SELECT DISTINCT Eliminate duplicated values more than two columns - considering all columns and show only unique values Find out unique values in columns *Challenge 1. show different prices that have been paid 2. order the prices from high to low LIMIT Used to limit the number of rows in the output Always a..