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 (24 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.

Struggling with your essay and deadlines?

Get this or a similar paper done in as fast as 4 hours, 24/7.

NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions

✔Secure Service ✔ Plagiarism Free ✔On-time Delivery

WRITE MY PAPER