• The whole query has char as the data type with the exception of 'rate' which is decimal