A logistics company wants to calculate each driver’s average…
A logistics company wants to calculate each driver’s average delivery time compared to the overall company average. Why are window functions a good choice here? OPTIONS:A. They permanently store averages in the databaseB. They allow calculations across related rows without reducing the datasetC. They are faster than all other SQL approachesD. They eliminate the need for any joins ANSWER:B EXPLANATION:Window functions allow calculations across groups (like averages by driver or company-wide) while keeping all rows visible. They don’t permanently store values (A), don’t always guarantee faster performance (C), and don’t eliminate the need for joins (D).