> What about other similar methods, such as sum(), average()?

They are not required by the interface so every dbms can implement them as they are supported.