The rows in the result established that has a NULL will be the extra rows added via the ROLLUP clause. A NULL price from the column abilities signifies a group of rows for a particular price of dept_id but with out a selected abilities value.Established ROWCOUNT alternative overrides the very best key word, In case the established worth of the ROWC