-- You can write ORDER BY and mention the columns based on which you want to order the data SELECT * FROM film ORDER BY release_year; -- sorting based in inc order of release_year SELECT * FROM film ...

*Theory: Views; Sorting data with ORDER BY clause (sort the data by one or more columns in the ascending and/or descending order); Filtering Data SELECT DISTINCT LIMIT WHERE clause Comparision and ...