sql query error Spring Boot Sql Query error

I am having issue this query i am getting error when c doesn’t have parent