13. Scenario 2, continued
Your team creates a highly effective prospects list for Food Justice Rock Springs. After a few months, many of these prospects become donors. Now, Tayen wants to know the top three cities in which these new donors live. She will use that information to determine if it’s still true that people who live closer to Rock Springs are more likely to donate.
What clause do you add to the following query to sort the donors in each city from high to low?
1 / 1 point
Correct
To retrieve the number of donors in each city, sorted high to low, the correct SQL query is:
SELECT COUNT (DonorID), City FROM new_donor_list GROUP BY City ORDER BY COUNT (DonorID) DESC
Related Questions & Answers:
- A data analytics team uses data about data to indicate consistent naming conventions for a project. What type of data is involved in this scenario? 2. A data analytics team uses data about data to indicate consistent naming conventions for a project. What type of ... Read more...
- You notice that the data in column E is an example of Boolean data. Why did you come to this conclusion? 2. Scenario 1 continued Next, you review the customer satisfaction survey data. To use the template for the customer satisfaction ... Read more...
- Sometimes during analysis, an analyst discovers that it’s necessary to adjust the business objective. When this happens, the analyst should take the initiative to do so without involving others in order to be respectful of their time. 8. Sometimes during analysis, an analyst discovers that it’s necessary to adjust the business objective. When this happens, the analyst ... Read more...
- Fill in the blank: Data analysts usually use _____ to deal with very large datasets. 1. Fill in the blank: Data analysts usually use _____ to deal with very large datasets. 1 / 1 point ... Read more...
- She asks: Is there a SQL function that can convert data types such as currency, dates, and times in a SQL table? 8. Scenario 2, continued Now, your interviewer explains that the data team usually works with very large amounts of customer ... Read more...
- An analyst notes that the “160” in cell A9 is formatted as text, but it should be Australian dollars. What spreadsheet tool can help them select the right format? 1. An analyst notes that the “160” in cell A9 is formatted as text, but it should be Australian dollars. ... Read more...