This project was created using PostgreSQL for SQL practice and data analysis.
- Books.csv
- Customers.csv
- Orders.csv
- PostgreSQL queries.sql
- SELECT statements
- WHERE clause
- JOINs
- Aggregate Functions
- GROUP BY
- Subqueries
- Foreign Keys
- COALESCE
- LEFT JOIN
To practice SQL queries on a bookstore dataset and solve business-related questions using PostgreSQL.
20 SQL queries