Need Answer To SQL Question

I would really appreciate it if someone could give me the answers or direct
me to a place that would have the answers to the following 5 questions.

1. I need an example of SQL select statement. (table tblSource, fields A,B,C
where C<100).. "is this an example that I have in ( )?

2. I need to list 3 table joins or is "inner, outer, left" etc actual table
joins? what are the others for my own knowledge.

3. Can you join a table to itself? (how? Alias.)

4. What is the diff, between distince and distinct row?

5. How would you check a value agains a lookup tableA? (IN) or is "IN" the
answer?

I am very sorry for my stupidy but I am trying to learn and my boss for one
reason or another gave me a ton of questions I cant answer.

Someone please help!