how to get that Id when the condition doesnot match : I have a table T. We have multiple records for a particular user_id with match type = "Red Card". I just wanted that user_Id and match_id which has never received a "Red Card" in a entire match.  

As per the table Image which is attached I would be getting output :
match_id : 3036 and 3090 and user_id 4 and 6 respectively[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/wm5Oy.png

Kindly help with the query.