Skip to main content
Skills
Free
Assessments
My progress
Home
Skills
SQL for Data Analysis (Beginner)
Text and Date Analysis
Practice
Free practice · matching · easy
Practice
Match text functions
Match each function to its common purpose.
Match each item
TRIM(subject)
Choose a match
Remove outside spaces
Convert letters to uppercase
Extract the first three characters
UPPER(subject)
Choose a match
Remove outside spaces
Convert letters to uppercase
Extract the first three characters
SUBSTR(code, 1, 3)
Choose a match
Remove outside spaces
Convert letters to uppercase
Extract the first three characters
Submit answer