COUNT(column) return the number of rows of a column without a NULL value MAX(column ) return the highest value of a column MIN(column) return the lowest value of a column SUBSTR('string', x, xx) ...