Need a little hand with 1 mSQL query that im unable to find a solution

hi, im looking for someone that is advanced in msql query and who can help me to solve 1 query problem i have actually please contact me via my profile if you are interested thanks