help with complex query

thanks for your track

it's correct

but i use join with another table ,that not correct

and distinct not work

please help me

thanks