It seems like you have accidentally included a large amount of unrelated text in your query.

How to Achieve Different Conditions on the Same Column Without Unexpected Results in SQL

How to Run Aggregate Functions on Grouped Records While Preserving Unique Values in SQL