Where can sub queries be placed in a SQL select statement

1) Where can sub queries be placed in a SQL select statement ?
2)what tables are good candidates for indexes and what type of indexes would you place on those tables?
3)what type of data model is used in data marts to improve performance?