Layer 1 The zip codes are in a column called zip_code. To select all data from the Donation_Form_List organized by zip code, you use the ORDER BY function. The syntax is: Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To retrieve only those records that include people who have served on the board of trustees or on the board of directors, you use the WHERE function. The syntax is: Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What is the section of a SQL query that will calculate the percentage of contributions from prospects? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which of the following tools will enable you to sort your spreadsheet by city (Column K) in ascending order? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To retrieve the number of donors in each city, sorted high to low, you use the following query: Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To change how cells appear, you use conditional formatting. Then, to highlight cells with a value of at least $100, you choose to format cells if they have a value greater than or equal to 100. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 The zip codes are in a column called zip_code. What query do you use to select all data from the Donation_Form_List organized by zip code? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What SQL function will return all records from the left table and only the matching records from the right? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You have performed the calculations for 2019, so now you move on to 2020. To return average contributions in 2020 (contributions_2020), you use the AVG function. You use the following section of a SQL query to find this average and store it in the AvgLineTotal variable: Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which SQL query will retrieve the number of donors in each city, sorted high to low? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What spreadsheet tool can you use to add a drop-down list with predetermined options for each city name? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To retrieve only those records that include people who have served on the board of trustees or on the board of directors, what clause do you include in your query? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 The correct syntax to count how many donations of $100 or greater appear in Column O is =SUMIF(O2:O210,”>=100″). Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which SQL query can be used to calculate the percentage of contributions from prospects? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: To add drop-down lists to your worksheet with predetermined options for each city name, you decide to use _____. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What clause do you add to the following query to sort the donors in each city from high to low? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which of the following spreadsheet tools will enable you to change how cells appear if they contain a value of $100 or more? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 What SQL function do you use to select all data from the Donation_Form_List organized by zip code? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To retrieve only those records that include people who have served on the board of trustees or on the board of directors, what is the correct query? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You start with 2019. To return average contributions in 2019 (contributions_2019), you use the AVG function. What portion of your SQL statement will instruct the database to find this average and store it in the AvgLineTotal variable? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Which of the following procedures will enable you to change how cells in your spreadsheet appear if they contain a value of $100 or more? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To move the 5-digit zip code in cell L2 into its own column, you use the function =LEFT(L2,5). Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You use a SQL function to instruct the database to combine the two columns into a new column called “address.” The syntax is: JOIN(street_address, ” to “, unit) as address. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You start with 2019. To return average contributions in 2019 (contributions_2019), you use the AVG function. What section of a SQL query will instruct the database to find this average and store it in the AvgLineTotal variable? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions