This SQL project create a database of great books and use it to make some simple and complex SQL queries. To replicate this project, you should run respectively the following SQL files:
- BooksDB_create.sql: to create the database Books and its 3 tables: a) tpublishers b) tauthors c) tbooks
- Books_insertdata.sql: to insert data into the tables.
- Queries.sql: to realized some queries to analyze data from the database Books.
Some queries are simple, such as displaying data from a table. Some other are more complex such as displaying some statistics related to books by publisher. The complex queries involve several tables and one or several sub-queries.