How to find persons who like red fruits or crunchy veggies?

The following dbd query finds persons who like either red fruits or
crunchy veggies:

(and (select person instance *)
       (select * like (or (and (select fruit instance *)
                                      (select * color red))
                               (and (select veggie instance *)
                                      (select * texture crunchy))
                          )
       )
)

What RMDB schema and SQL query will find the equivalent? Should I start
with T_Person, T_Fruit, T_Veggie, T_PLikeF, T_PLikeV ?