Brillio Interview Question

Asked 3 SQL queries 1.to return salary greater than 100000 2.To return unique elements 3.To count duplicate elements