SELECT description, LENGTH(TRIM(description)) - LENGTH(REPLACE(TRIM(description), ' ', '')) + 1 FROM test.city