1.MIN()         --->  SELECT MIN(AnnualRevenue) FROM Account

2.MAX()         ---> SELECT MAX(AnnualRevenue) FROM Account

3.AVG()         ---> SELECT AVG(AnnualRevenue) FROM Account

4.SUM()         ---> SELECT SUM(AnnualRevenue) FROM Account

5.COUNT()       ---> SELECT COUNT(Id) FROM Account

   

6.Parent To Child  --->  SELECT Name, (SELECT Id, FirstName FROM Contacts) FROM Account   

7.Child  To Parent --->  SELECT Account.Name, COUNT(Id)FROM Contact GROUP BY Account.Name

    

8.ROll UP()    --->  SELECT Industry, COUNT(Id) FROM Account GROUP BY ROLLUP(Industry)

                                                    

9.ORDER BY       ---> SELECT Name FROM Account  ORDER BY Name ASC  -->(by Default)

10.ORDER BY       ---> SELECT Name FROM Account  ORDER BY Name DESC    

    

11.GROUP BY       ---> SELECT Industry, COUNT(Id) FROM Account GROUP BY Industry     

12.HAVING           ---> SELECT Name, SUM(AnnualRevenue)FROM Account GROUP BY Name HAVING SUM(AnnualRevenue) > 10000