Question: 1. what is an offset and how is it used?
Answer: The OFFSET argument is used to identify the starting point to return rows from a result. OFFESET is called an argument since it is technically part of the ORDER BY clause. The OFFSET is the number of rows to skip before including them in the result. Where the rows-to-skip is an value greater than or equal to zero.