vet clinic db is a repository showing steps on how to create an animal clinic and query data from the database
Database
In this repository you can query:
- How many animals there are.
- How many animals have never tried to escape.
- The average weight of animals.
- Find Who escapes the most, neutered or not neutered animals
- The minimum and maximum weight of each type of animal.
- The average number of escape attempts per animal type of those born between 1990 and 2000.
This project was written on windows platform and used PostgreSQL version 16.
To get a local copy up and running, follow these steps.
In order to run this project you need:
-
Postgresql installed and configured properly. Guide
-
Basic understanding of structured query language(SQL)
Clone this repository to your desired folder:
Example commands:
cd my-folder
git clone https://github.com/NoelLincoln/vetclinic-db.git
Using SQL shell(psql) or pgAdmin 4:
- Create the database and animals table using the commands from schema.sql
- Insert sample data from data.sql
- Query inserted data using sample queries in 'queries.sql'
👤 Noel Bryant
- GitHub: @githubhandle
- Twitter: @twitterhandle
- LinkedIn: LinkedIn
- Query percentage of animals under 10kg
- Query average weight for animals under 4 years
Contributions, issues, and feature requests are welcome!
Feel free to check the issues page.
If you like this project feel free to
I would like to thank the entire Microverse Community
This project is MIT licensed.