View — A virtual table based on the tables that already exist.
Order by — The clause that can put tuples by certain orders.