how do i write a query for-"Plan not delivered in 30 days; Critical is 15 days"

[Priyanka Khare]

if suppose there is a transition-"plan not delivered" , how do i write a query for-"  Plan not delivered in 30 days; Critical is 15 days"