Write a SQL Report of a Data and Explain Why One by One

SQL Project – Novotny Bookstore

This project uses the Novotny_Bookstore.accdb database. You need to write SQL queries in Microsoft Access and provide:

• The SQL query
• Screenshot of the query result
• Short explanation (2–4 sentences)

There are 5 tasks:

1. List books written by each author
   Join Author, Author_Book, and Book tables.
2. Show how many books each author wrote
   Use COUNT() and GROUP BY.
3. Get customer emails for shipped books
   Join Customer and Sales_Line_Item.
4. Show how many copies of each book were sold
   Use SUM(Quantity) and GROUP BY Book.
5. Calculate total sales amount on September 1, 2023
   Filter by date and use SUM(Quantity × Unit_Price).

Everything should be written in Access SQL and clearly organized per question.