A list of Publishers those who belong to USA and
a substring from the name which is starting at position four and five
characters long:
Publishers | SUBSTRING(pub_name,4,5) |
Jex Max Publication | Max |
Mountain Publication | ntain |
Summer Night Publication | mer N |