Salesforce CRM by Sreedhar

 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)                                                   ...