Build a portfolio of SQL projects, starting small and then moving to more complex ones. Showcasing these on platforms like ...

A relational database project for managing an online bookstore, including books, customers, and orders. The project also contains solved SQL queries for beginner to advanced analysis.

Indexing: An index on customer_state improves performance for GROUP BY and WHERE clauses on that column. JOIN queries are provided as templates; they require additional Olist tables.