Most likely JMP's SQL GUI doesn't support all possible SQL commands and functions which are available depending on which SQL is being used but you could convert the query to Custom SQL and add those yourself
or something is maybe found from computed columns
-Jarmo