1.  
2. Retrieve all Case Records along with their Status & Case Numbers in your system.
3. Retrieve all the Contact records with their Name & Email where Email of the Contact is not null.
4. Retrieve the Names & Amounts of all Opportunity records with an Amount greater than $10,000.
5. Retrieve all the Account records with their Name & Billing City, As their billing city either ‘New York’ or ‘San Francisco’.
6. Retrieve the Names of Contact records for all Account Records with the Name of an Account.
7. Retrieve the Name & Type of all Account records where the Type field is either ‘Prospect’ or ‘Customer – Direct’.
8. Retrieve the CaseNumber, Status, Priority of all Case records with a Status of ‘Closed’ and a Priority of ‘High’.
9. Retrieve the Name, MailingState & MailingCity of all Contact records with a MailingState of ‘California’ and a MailingCity of ‘San Francisco’.
10. Retrieve all Account records those are having Parent Account(By using ParentId).
11. Retrieve the Contact records where the LastName starts with the letter “S”.
12. Retrieve the Case records with a Description containing the word “urgent”.

Trailhead Exercise:

SOQL for Admins : https://trailhead.salesforce.com/content/learn/modules/soql-for-admins?trail_id=build-apex-coding-skills

Quick Start: Apex Coding for Admins : https://trailhead.salesforce.com/content/learn/projects/quick-start-apex-coding-for-admins