Multiple And condition in Where Clause in Sql : I have a table like this

ID   Process  Work

A1   | 0 |       Done                                                                                                                                               
A1   | 1 |       Progress                                                                                                                                               
A2   | 0 |       Done                                                                                                                                               
A2   | 1 |       Done                                                                                                                                               
A2   | 2 |       Progress  
A3   | 0 |       Done                                                                                                                                               
A3   | 1 |       Done                                                                                                                                               
A3   | 2 |       Progress 

I need to output ID of only that work whose Process=0 and Work=Done and if Process>0 and Work=Progress. Hence in this case it will output only A1 since for Process>0 A2 and A3 have Work=Done.

How do I use multiple And statements in where condition?
