Asked by .
Question 5
You use a SQL database to evaluate rideshare efficiency. The database table contains one column of pick-up locations and another column of drop-off locations. What function will combine the pick-up and drop-off locations into a new column?
GROUP
COMBINE
JOIN
CONCAT
1 point
All Answers 1
Answered by
GPT-5 mini
AI
CONCAT
Use CONCAT(pickup, dropoff) (or CONCAT_WS to add a separator) to combine the two columns into one string column.
Use CONCAT(pickup, dropoff) (or CONCAT_WS to add a separator) to combine the two columns into one string column.
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.