7. Scenario 1, continued
You finish cleaning your datasets, so you decide to review Tayen’s email one more time to make sure you completed the task fully. It’s a good thing you checked because you forgot to identify people who have served on the board of directors or board of trustees. She wants to write them a thank-you note, so you need to locate them in the database.
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:
1 / 1 point
Correct
To retrieve only those records that include people who have served on the board of trustees or on the board of directors, the syntax must include “OR.” Including “AND” will only retrieve records of people who served on both boards. The syntax is:
Related Questions & Answers:
- Adding descriptive headers to columns of data in a spreadsheet is an example of which analytical skill? 2.Adding descriptive headers to columns of data in a spreadsheet is an example of which analytical skill? 1 / 1 point Data ... Read more...
- Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____. 4.Fill in the blank: The data life cycle has six stages, whereas data analysis has six _____. 1 / 1 point key ... Read more...
- Fill in the blank: A problem is an obstacle to be solved, an issue is a topic to investigate, and a _____ is designed to discover information. 3.Fill in the blank: A problem is an obstacle to be solved, an issue is a topic to investigate, and ... Read more...
- Next, you create a slideshow, which includes a data visualization to highlight the Splashtastic sales insights you’ve discovered. You’ve reached which phase of the data analysis process? 5. Scenario 1 continued Next, you create a slideshow, which includes a data visualization to highlight the Splashtastic sales insights ... Read more...
- What is an example of using a metric? Select all that apply. 5. What is an example of using a metric? Select all that apply. 1 / 1 point Using annual profit ... Read more...
- A data analyst might use descriptive column headers in order to achieve what goal? 8. A data analyst might use descriptive column headers in order to achieve what goal? 1 / 1 point Add context to ... Read more...