Find UK Author Books
Find all books written by authors from the UK, showing the book title and author's last name.
Reference Tables
Authors
(authors)
| id | first_name | last_name | birth_year | country |
|---|---|---|---|---|
| 1 | William | Shakespeare | 1564 | UK |
| 2 | Charles | Dickens | 1812 | UK |
| 3 | Taras | Shevchenko | 1814 | Ukraine |
| 4 | J.K. | Rowling | 1965 | UK |
| 5 | Gabriel García | Márquez | 1927 | Colombia |
| 6 | Mark | Twain | 1835 | USA |
| 7 | George | Orwell | 1903 | UK |
| 8 | Ernest | Hemingway | 1899 | USA |
| 9 | Agatha | Christie | 1890 | UK |
| 10 | Miguel de | Cervantes | 1547 | Spain |
Books
(books)
| id | title | publication_year | pages | author_id |
|---|---|---|---|---|
| 1 | Romeo and Juliet | 1597 | 96 | 1 |
| 2 | A Tale of Two Cities | 1859 | 489 | 2 |
| 3 | Kobzar | 1840 | 245 | 3 |
| 4 | Harry Potter and the Philosopher's Stone | 1997 | 223 | 4 |
| 5 | One Hundred Years of Solitude | 1967 | 417 | 5 |
| 6 | The Adventures of Huckleberry Finn | 1884 | 366 | 6 |
| 7 | 1984 | 1949 | 328 | 7 |
| 8 | The Old Man and the Sea | 1952 | 127 | 8 |
| 9 | And Then There Were None | 1939 | 272 | 9 |
| 10 | Don Quixote | 1605 | 863 | 10 |