help with mysql

[d d]

i dont know how to make a query...does anyone know how to do any of these???


-Prepare a query which shows employee name, job title, and date of hire for employees with salary less than or at most equal to $2,000.

-Prepare a query that shows employee name and salary for employees whose name contains an "M".

-Prepare a query that shows all information from the employee table about employees who are managers or analysts. The result list should be sorted by date of hire.

-Prepare a query that shows all information from the employee table about employees whose name contains a "T" who are either salespeople or clerks.

-Prepare a query that shows name and job title of all employees hired during last half of 1991 who are neither salespeople nor clerks.

-Prepare a query which shows employee name, job title, hire date, and salary for all employees who were hired after 1991. Sort the result list by employee name within job title.

-Prepare a query that shows the employee name and job title for all employees who have non-blank value for commission.

-Prepare a query that shows the employee name, job title and department number where the employee is a salesperson or the employee is a manager with a salary greater than $3,000.

-Prepare a query that lists all the job titles non-redundantly.