## Tables

$1.$ Authors $-$ stores information about authors

$|$ author$\_$id $($Primary Key$)|$ first$\_$name $|$ last$\_$name $|$ country $|$ birth$\_$date $|$

$1.$ Books $-$ stores information about books

$|$ book$\_$id $($Primary Key$)|$ title $|$ ISBN $|$ publication$\_$date $|$ publisher$\_$id $($Foreign Key$)|$

$1.$ Publishers $-$ stores information about publishers

$|$ publisher$\_$id $($Primary Key$)|$ name $|$ country $|$ website $|$

$1.$ Book$\_$Authors $-$ stores the relationship between books and authors

$|$ book$\_$id $($Foreign Key$)|$ author$\_$id $($Foreign Key$)|$

## Questions

Develop six$(6)$ questions and answer these questions.

Requirements:

$-$ Question $1$ should be a query with a composite condition from one table.

$-$ Question $2$ should be a query with a composite condition and two tables.

$-$ Question $3$ needs the GROUP BY clause and a aggregate function.

$-$ Question $4$ needs both WHERE clause and the HAVING clause.

$-$ Question $5$ needs to use a subquery and the EXISTS keyword.

$-$ Question $6$ needs two subqueries and the ALL keyword.

## Database and Query Results

Please generate some data and insert into a sqlite database. You need to run the six queries developed above and show the result. Make a screenshot of each result.