SQL to sp_executesql

You will get this...

EXEC sp_executesql N'select * from CUSTOMER c
join ORDER o on o.CUSTOMER_ID = c.ID
where o.DATE > @p1
and c.ZIP_CODE = @p2',

--parametr definitions
N'@p1 DATETIME2,
  @p2 BIGINT',

--parametr values
  N'10',
  12345