Created
March 23, 2020 01:27
-
-
Save niavesper/e874cbe8cf887c137a8316aa60026cbe to your computer and use it in GitHub Desktop.
Week6_Homework_SOQL_And_Loops
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public with sharing class WeekSixHomework { | |
public static void soqlPractice() { | |
//1. Below is a SOQL query that should be returning the top 5 Accounts in our org based on Annual Revenue. | |
//Something's not quite right, can you fix the query? | |
List<Account> topFiveAccounts = [SELECT Id, Name, AnnualRevenue FROM Account WHERE AnnualRevenue != 0 ORDER BY AnnualRevenue DESC LIMIT 5]; | |
System.debug('This should be 5: ' + topFiveAccounts.size()); | |
//2. Here is a query that is missing something. It compiles, but if you try and run this method in Anonymous | |
//you'll get an error when the method tries to use the query results. Fix it! :) | |
List<Contact> contacts = [SELECT FirstName, LastName, MailingState FROM Contact LIMIT 10]; | |
for (Contact c : contacts) { | |
String name = c.FirstName + ' ' + c.LastName; | |
} | |
//3. Can you write a SOQL query from scratch that will return the top 10 Accounts in the org, ordered by annual | |
//revenue in decending order? Print your results in the debug log. | |
List<Account> topTenAccs = [SELECT Name, AnnualRevenue from Account WHERE AnnualRevenue !=Null ORDER BY AnnualRevenue LIMIT 10]; | |
For (Account acc : topTenAccs){ | |
System.debug('Account name: ' + acc.Name + '; annual revenue: ' + acc.AnnualRevenue); | |
} | |
//4. Can you write a SOQL query that will return all opportunities for all accounts in the topFiveAccounts list that we used | |
//in Number 1? (topFiveAccounts) Hint: If you're stuck, look back a the code in WeekSixClassExercises, getOpenOppsForHotAccounts method | |
// Print your results in the debug log. | |
List<Opportunity> oppsFromTopFiveAccs = [Select Id, AccountId, Name FROM Opportunity WHERE AccountId in :topFiveAccounts]; | |
System.debug('These are opportunities from top 5 accounts: '+ oppsFromTopFiveAccs); | |
} | |
public static void forTheLoveOfForLoops() { | |
//1. Take a look at the list and loop below. It's commented out since it can't run as is. | |
// Can you replace the ?? with the number that makes sense based on the comments? | |
// Remove the slashes and compile. | |
// Can you add an extra counter variable so that you can print out how many times the loop ran in total? | |
//This loop should run 5 times | |
Integer j = 0; | |
for (Integer i=0; i<5; i++) { | |
System.debug('i is now: '+i); | |
j = j+1; | |
} | |
System.debug('This is how many times the loop ran: ' + j); | |
//2. Below is a loop that iterates through a list. Can you change it to use the new For Loop syntax? It should print out | |
//each account name in the debug log when you're done. | |
//Use the list size to tell you how many loops, and use indexing to fetch values. If you need help, check the | |
//loopingThroughLists method in WeekThree for hints | |
List<Account> accountList = [SELECT Id, Name FROM Account LIMIT 5]; | |
for (Integer i=0; i<accountList.size(); i++) { | |
System.debug('Account #' + i + ': ' + accountList[i].name); | |
} | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Awesome work..good understanding of SOQL 👍