The rows in the result set using a NULL will be the extra rows added through the ROLLUP clause. A NULL price during the column expertise implies a bunch of rows for a particular price of dept_id but with out a certain skills worth.The very best clause allows us to limit the result set of the queries according to the quantity of rows or the percenta