Select OrderID = Case OrderID When 1 Then 'Customer1' When 2 Or 3 Then 'Customer2' Else 'Unknown Customer' End From OrdersPlaced
Select OrderID = Case OrderID When 1 Then 'Customer1' When 2 Or 3 Then 'Customer2' Else 'Unknown Customer' End From OrdersPlaced