Notes :

1. Utilize the COUNT() method to examine total records.

SELECT COUNT() FROM Account

1. Fetch those Account records whose name starts with ‘Tech School’.

SELECT Id, Name FROM Account WHERE Name LIKE 'Tech School%'

1. Ordering in SOQL.

SELECT Id, Name FROM Account WHERE Name LIKE 'Tech School%' ORDER BY Name DESC

1. Parent-to-Child Communication in SOQL

SELECT Id, Name, (SELECT Id, Name FROM Marks__r) FROM Student__c;

     Note: Here **Marks__r** is a Child Relationships name in Mark Object.

1. Child-to-Parent Communication in SOQL

SELECT Id, Name, Student__r.Name FROM Marks__c;

for (Marks__c item : [SELECT Id, Name, Student__r.Name, Student__r.student_phone__c FROM Marks__c] ) {
            System.debug(item.Student__r.student_phone__c);
        }

1. Parent to Child For Loop in SOQL