SQL how to show all of the software but compulsory column will only show if is “Compulsory” [closed]

I wanted to see all of the software but compulsory column will only show if is “Compulsory” and will show NULL if is ‘Not Compulsory’.Here is the table

You Might Also Like