Skip to Content
May 09, 2018 at 08:37 PM

Flexible search query


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({}) FROM {User as u JOIN Order as o ON {} = {o.user} } WHERE {Order} is null }}) as x

Really appreciated for reply