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 nameSUBSTR(pub_name,4,5)