Question 5: (1.00) If you skip the PARTITION BY clause, the window function will… treat the whole result set as a single partition divide rows into multiple groups specify the order of rows in each partition define a subset of rows in the current partition

What is the purpose of the PARTITION BY clause in an aggregate function using windows in SQL?Review LaterTo group the result set into categoriesTo specify the column on which the calculation should be performedTo specify the window over which the calculation should be performedTo perform the calculation on a subset of the result set

The ROW_NUMBER() function…assigns a sequential number to each row in each partition assigns ranking within an ordered partition. If rows have the same values, the function assigns the same rank, with the next ranking(s) skipped assigns a rank to each row within an ordered partition, but the ranks have no gap. In other words, the same ranks are assigned to multiple rows and no ranks are skipped returns a value evaluated against the first row within its partition returns a value evaluated against the last row in its partition

The GROUP BY clause indicatesthe list of row conditions.the list of row summary conditions.the list of aggregate functions.the list of grouping columns for calculation of aggregate functions.

Question 7: (1.00) When you use the GROUP BY clause without applying an aggregate function, it works like… the LIMIT clause the HAVING clause the DISTINCT clause the ORDER BY clause the JOIN clause

Which SQL clause is used to specify the order of rows in a result set?OptionsHAVINGORDER BYSORTGROUP BY