Hi Experts , Could you please help me on below query as i didn't get result as expected .
Query :
No. of users with who have never placed an order
SELECT COUNT(*) FROM ({{ SELECT DISTINCT({u.pk}) FROM {User as u JOIN Order as o ON {u.pk} = {o.user} } WHERE {Order} is null }}) as x
Really appreciated for reply