Next, you duplicate your dataset twice using the Sheet Menu. You rename the first sheet Donation Form List, and you remove the cities that are further than 50 miles from Rock Springs. You rename the second sheet Postcard List, and you remove the cities that are within 50 miles of Rock Springs.
Then, you import these datasets into your company’s mailing list database. In a mailing list database, you create two tables: Donation_Form_List and Postcard_List. You decide to clean the Donation_Form_List first.
Your company’s mailing list software requires units to be on the same line as street addresses. However, they are currently in two separate columns (street_address and unit).
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.
Correct
To combine the two columns into a new column called “address,” the syntax is: CONCAT(street_address, " to ", unit) as address.
Related Questions & Answers:
- Conditional formatting is a spreadsheet tool that changes how cells appear when values meet a specific condition. Data analysts can use conditional formatting to do which of the following tasks? Select all that apply. 1. Conditional formatting is a spreadsheet tool that changes how cells appear when values meet a specific condition. Data analysts ... Read more...
- The analyst wants to return a list of all unique customer IDs to identify the states in which they have customers. What is the correct SQL clause to retrieve the customer IDs? 4. A data analyst is cleaning customer data for an online retail company. They are working with the following section ... Read more...
- Without enough data to identify long-term trends about the video subjects that people prefer, what are your available options? Select all that apply. 2. Scenario 1 continued During the meeting, you also learn that Meer-Kitty videos are hosted on their website. For each ... Read more...
- Fill in the blank: Sorting ranks data based on a specific _____ that you select. 4. Fill in the blank: Sorting ranks data based on a specific _____ that you select. 1 / 1 point ... Read more...
- Fill in the blank: A data analyst is working with a spreadsheet that has very long text strings. They use the LEN function to count the number of _____ in the text strings. 6. Fill in the blank: A data analyst is working with a spreadsheet that has very long text strings. They ... Read more...
- A data analyst writes a query that asks a database to return only distinct values in a specified range, rather than including repeating values. Which function do they use? 7. A data analyst writes a query that asks a database to return only distinct values in a specified range, ... Read more...