Please explain the definition of below terms and give an example for each term:

1. ORDER BY ... DESC

2. ORDER BY ... ASC

3. Primary Sort vs Secondary Sort

4. Wild card Characters (% and _)

5. List all Logical Comparison Operators and give two examples for two of the comparison operators