Fixed Statement in Custom SQL

Hi,

I was wondering if there was any way to use a fixed statement in custom SQl

in my WHERE statement I have "WHERE c2.C_ORDR_WK_TYP <>'EXPECTED #1'" which gives me the correct field outputs, but in my output, it puts all of the work types. In Tableau I can easily fix this using a calculated field and saying "{FIXED [Order1]: MAX([WorkType])}" but is there a way to do this in the SQL custom code?

Thank you !