Thank you for visiting ITKE.
We are happy to help you with solving specific IT questions, but need as
much information as possible to do so. Let us know about the problem you
are trying to solve, how you are approaching it and what work you’ve
done so far, and we can help guide you in the right direction.
-For questions 1-4, you might need to use the LIMIT clause, and/or some trick to add row numbers to your query results (for example SELECT @r:=@r+1 AS rownum, …).
-Questions 5-9 are fairly simple, and if you are not able to answer them, you really need to study.