A list of Publishers those who belong to USA. Second column shows a string containing 5 characters from the fourth position of the Publisher's name :
Publishers name
SUBSTR(pub_name,4,5)