A list of Authors with their id, name country and home city. The list set against a condition, and that is, Author's name should not end with 'on' and also not with 'an':
Author's id | Author's name | Country | Home city |
AUT002 | William Maugham | Canada | Toronto |
AUT003 | William Anthony | UK | Leeds |
AUT008 | Nikolai Dewey | USA | Atlanta |
AUT009 | Marquis de Ellis | Brazil | Rio De Janerio |
AUT011 | John Betjeman Hunter | Australia | Sydney |
AUT012 | Evan Hayek | Canada | Vancouver |
AUT013 | E. Howard | Australia | Adelaide |
AUT014 | C. J. Wilde | UK | London |
AUT015 | Butler Andre | USA | Florida |