select column1,colum2 
from table1 
where column1 = 'bob'

##</code><code>##

select col1,col2 
from table1,table2 
where table1.col1='bob' and table2.col2=table1.col2

##</code><code>##

select * 
from table 
where col1*2 = 50