Create this tables and execute the query:-
Author Table:-
| id | name | birth_year | death_year |
|---|---|---|---|
| 1 | Marcella Cole | 1983 | NULL |
| 2 | Lisa Mullins | 1891 | 1950 |
| 3 | Dennis Stokes | 1935 | 1994 |
| 4 | Randolph Vasquez | 1957 | 2004 |
| 5 | Daniel Branson | 1965 | 1990 |
Book Table:-
| id | author_id | title | publish_year | publishing_house | rating |
|---|---|---|---|---|---|
| 1 | NULL | Soulless girl | 2008 | Golden Albatros | 4.3 |
| 2 | NULL | Weak Heart | 1980 | Diarmud Inc. | 3.8 |
| 3 | 4 | Faith Of Light | 1995 | White Cloud Press | 4.3 |
| 4 | NULL | Memory Of Hope | 2000 | Rutis Enterprises | 2.7 |
| 5 | 6 | Warrior Of Wind | 2005 | Maverick | 4.6 |
Adaptation Table:-
| book_id | type | title | release_year | rating |
|---|---|---|---|---|
| 1 | movie | Gone With The Wolves: The Beginning | 2008 | 3 |
| 3 | movie | Companions Of Tomorrow | 2001 | 4.2 |
| 5 | movie | Homeless Warrior | 2008 | 4 |
| 2 | movie | Blacksmith With Silver | 2014 | 4.3 |
| 4 | movie | Patrons And Bearers | 2004 | 3.2 |
book_review Table:-
| book_id | review | author |
|---|---|---|
| 1 | An incredible book | Sylvia Jones |
| 1 | Great, although it has some flaws | Jessica Parker |
| 2 | Dennis Stokes takes the reader for a ride full of emotions | Thomas Green |
| 3 | Incredible craftsmanship of the author | Martin Freeman |
| 4 | Not the best book by this author | Jude Falth |
| 5 | Claudia Johnson at her best! | Joe Marqiz |
| 6 | I cannot recall more captivating plot | Alexander Durham |
- List All Books and Their Authors.
- List Authors and Books Published After 2005.
- Show Books Adapted Within 4 Years and Rated Lower Than the Adaptation.
- Show All Books and Their Adaptations (If Any).
- Show All Books with Their Reviews (If Any).
- List All the Books and All the Authors.