please suggest a syntax or query to solve the problem