Resets the wait statistics for an instance of SQL Server

DBCC SQLPERF("sys.dm_os_wait_stats",CLEAR);

Group by with Rollup

GROUP BY .... WITH ROLLUP

"with Rollup" uses to aggregate sub-groups in a group statement.

An example will be better than any explanation: