I will write and debug sql queries
Ecommerce Data Analyst Excel and Ad Spend Reporting
About this Gig
Need help writing SQL queries, fixing errors, or analyzing data from your database? I can help you write and debug SQL queries for reporting and data analysis.
What I can help with:
- SELECT, WHERE, ORDER BY and filtering
- JOINs and combining tables
- GROUP BY and aggregate functions
- Subqueries and common table expressions (CTEs)
- Window functions where appropriate
- Sales, customer and e-commerce data analysis
- Debugging existing SQL queries
What you will receive:
- Clear, organized SQL queries
- A .sql file containing the completed queries
- A brief explanation of the query logic
- Testing against supplied sample data when available
I primarily work with SQLite and can consider MySQL tasks depending on their requirements.
Before ordering: Please provide your table structure, explain the question you want answered, and describe the expected output. If you need debugging, include your existing query and error message.
Packages cover a defined number of queries. Complete database development, live integrations, scheduled automation and advanced performance optimization are not included unless agreed upon separately.
Database type:
Relational database
Platform:
MySQL
•
Oracle
•
SQLite
•
SQL Server
Expertise:
SQL
•
DDL
•
DML
•
DQL
My Portfolio
FAQ
Which SQL databases do you support?
I primarily work with SQLite. I can consider MySQL and other SQL dialects depending on the task. Please contact me before ordering if you use a different database.
What information should I provide?
Please provide your table schema or CREATE TABLE statements, the task you want to solve, and the expected output. Sample data is helpful. For debugging, include your current query and any error message.
Can you fix an existing SQL query?
Yes. Send me your query, the error message or incorrect result, and what you want the query to return.
Do you test the queries?
I can test queries when suitable sample data and the required database environment are available. If you provide only the schema, I can review the query but may not be able to verify its results against actual data.
Can you write JOINs, CTEs and window functions?
Yes, for tasks within my supported SQL knowledge and the selected package scope. Please share complex requirements before ordering so I can confirm the scope.
Do you build complete databases or automate scheduled queries?
This gig focuses on writing, debugging and explaining SQL queries. Complete database systems, live integrations, scheduled automation and advanced database performance tuning are outside the standard packages.

