In a customer database, how would you use aggregate functions to determine the average age of all customers?
- AVG(age)
- MAX(age)
- MIN(age)
- SUM(age)
To determine the average age of all customers, you would use the AVG() aggregate function. This function calculates the average value of the specified column, providing the mean age of all customers in the database.
Loading...
Related Quiz
- How can branching strategies in version control impact Entity Framework migrations?
- Which approach allows for configuration of relationships without modifying the entity classes?
- In a scenario where a migration caused a data loss, how would you identify and rectify the issue using Entity Framework tools?
- When using Code-First approach, how do you create an index that spans multiple columns?
- In advanced scenarios, the ________ method in Fluent API is used to configure complex inheritance mappings.