In this repository you will find my answers to the SQL challenges proposed on the StrataScratch website. The available questions are listed below. Each link leads to the document containing both the question statement and the answer, written in PostgreSQL.
- Count the number of companies in the Information Technology sector in each country
- Salaries differences
- Finding updated records
- Workers with the highest salaries
- Finding user purchases
- Classify business type
- Most profitable companies
- Users by average session time
- Acceptance rate by date
- Highest Target Under Manager
- Counting Instances in Text
- Monthly Percentage Difference
- Premium vs Freemium
- Popularity Percentage
- Top 5 states with 5 star businesses
If you have any feedback, please reach out to me at martacasdelg@gmail.com