Is there a way, I dont have to have two tables. Becasue what im trying to prevent is making two tables. But have all this in a select statement. To prevent confusing, all is on one table so I just need one select query that can do all what i provided above.