Need some examples for Expressions

[#1]

Hi,

Can someone provide examples for Expressions for where and if statements. I am a beginner and could not find relevant examples in the tutorial.

I am looking for the correct syntax for the below expression:

1. count (NUMBER) where ACK is not null and priority is low and ACKTIME < 3600
2. count (NUMBER) where STATUS = "Resolved or Closed" and CLOSEDATE is between "dd-mm-yyyy" and "dd-mm-yyyy"

Thanks in advance.

[#2]

1. count (NUMBER) where ACK is not null and priority is low and ACKTIME < 3600 Ans: count(if(isnull(ACK)=0 and priority='low' and ACKTIME<3600,NUMBER))
2. count (NUMBER) where STATUS = "Resolved or Closed" and CLOSEDATE is between "dd-mm-yyyy" and "dd-mm-yyyy"   Ans: Count(if(wildmatch(STATUS,'Resolved','Closed') and CLOSEDATE>=date('27-05-2012','dd-mm-yyyy') and CLOSEDATE<=date(today(),'dd-mm-yyyy'),NUMBER))