Custom SQL

Hi,
I have a sql statement: 
SELECT [ItemName], [Startprice], [Percentreduction], [Quantityavailable], [PhotoURL], [proID] FROM [items] WHERE ([featured] = @featured)
 
but I would like to add in 2 more where clauses. One is AND (aswell as) the current one, so
WHERE ([featured] = @featured) AND ([Quantityavailable > @Quantityavailable)            ?(@Quantity available value set to 0)(is that right?)
and also I want another AND which is taken from another column. i.e:
WHERE ([featured] = @featured) AND ([Quantityavailable > @Quantityavailable) AND ([numberclickedin< *the number from the numtaken column*])
 
So I guess my 2 questions are:
1. is the format right for my custom sql statements.
2. how do I get the number from the numtaken column to dynamically enter into the third statement?
 
Thanks,
Jon