SQL内部加入并过滤掉结果

I'm doing a query for a report, and I need help with the INNER JOINs I've been trying to make work for weeks. Its apart of a larger report query, but I need help in this final part taht is supposed to filter certain results.I'm doing a query for a report, and I need help