I need some example code for these 12 in mysql:

1-Retrieve subset of columns.

2-Uses a simple condition.

3-Uses a compound condition.

4-Uses the LIKE, IN, or BETWEEN operator.

5-Uses an aggregate function.

6-Uses the GROUP BY clause.

7-Uses joins to retrieve data from more than one table.

8-Use the IN or EXISTS operator.

10-Use a subquery.

11-Performs an inner or outer join.

12-Uses ALL or ANY operators.