About Lesson
- Retrieve the CaseNumber & CreatedDate of all Case records created in this Week.
- Retrieve the CaseNumber & CreatedDate of all Case records created in Last Month.
- Retrieve the Case records created in the last Quarter.
- Retrieve the Id & CloseDate of all Opportunity records with the CloseDate in the Current Quarter.
- Retrieve the Opportunity records with a StageName of “Closed Won” and Lead Source as “Partner Referral”.
- Retrieve all the contacts associated with an account named “Acme Corporation.”
- Find all the opportunities related to an account with a specific industry, such as “Technology.”
- Retrieve all the tasks associated with an opportunity with a specific name, like “Big Deal.
- Find all the opportunities that have a related contact with the title “Manager.”
- Retrieve the names of all the opportunities that are associated with an account in a specific industry, such as “Healthcare.”
- Query the records based on the below criteria.
- Query the records based on the below criteria.
Step 1: Retreive Name, Department and Title from Contacts.
Step 2: Retreive All case(Case Number, Subject) raised by a contact.
Step 3: Get Parent Account's Name, Rating for each contact.
Step 4: Make sure Account fields are the initial columns in the result.
Step 5: Retreive only those records where Account rating is Hot.
Step 6: Sort the results by contact name.
Step 7: Only retreive Open Cases.
Step 8: Add one more filter, Contact department must be equals to Technology.