List Non Duplicate Data in a table

Hi,
If you need to display only non Duplicate datas in a table. That can be done by using the key word DISTINCT
e.g;
>SELECT DISTINCT FIELD_NAME FROM TB_NAME;

Similarly for get average of a particular field
>SELECT AVG(FIELD_NAME) FROM TB_NAME;