I will write sql queries for postgresql or sqlite and visualize results
software dev
Über diesen Service
Need answers from your database? I will write SQL queries for PostgreSQL or SQLite and turn the results into clear charts with Python.
WHAT YOU GET
- SQL queries: JOIN, GROUP BY, and window functions (LAG, SUM OVER, moving averages) - Debugging of queries that return errors or wrong results - Your CSV or Kaggle-style dataset loaded into PostgreSQL or SQLite - Matplotlib charts saved as PNG (Standard and Premium) - A Python script to connect to your database with psycopg2, SQLAlchemy, or sqlite3 (Premium)
PACKAGES - Quick Queries: 3 queries - Queries + Charts: 7 queries + 2 charts - Full Package: 10 queries + 4 charts + Python script
DELIVERY .sql files with comments, chart images, and a short note explaining how to run everything.
IMPORTANT 1 query = 1 SQL query that answers one question.
BEFORE ORDERING Message me with your data (or a small sample) and the questions you want answered, so I can confirm the scope and the best package.
Your data stays private and is used only for your order.
Datenbanktyp:
Zentralisierte Datenbank
•
Relationale Datenbank
Plattform:
PostgreSQL
•
SQLite
Expertise:
SQL
•
DDL
•
DML
•
DQL

