I will write or fix sql select queries for your reports
Computer Science Student
About this Gig
Need a SQL query for a report, or help fixing one that returns incorrect results?
I will write or fix one SELECT query using up to 2 tables in MySQL, PostgreSQL, SQL Server, or Oracle. Each order covers one database engine and version.
WHAT IS INCLUDED:
- 1 SELECT query created or corrected.
- Filters, sorting, a JOIN, and basic aggregations such as SUM or COUNT.
- A .sql file with readable formatting and comments.
- A brief explanation of how the query works.
- Validation against the sample data and expected results you provide.
- Delivery within 3 days and 1 revision within the agreed scope.
WHAT I NEED:
Your database engine and version, table definitions, anonymized sample data, and the expected output. For fixes, include the existing query and any error message.
This package excludes database administration, data changes, stored procedures, query scheduling, performance tuning, dashboards, and application integration.
Please message me before ordering to confirm compatibility and scope. Do not send passwords or production access credentials.
Database type:
Relational database
Platform:
MS SQL
•
Oracle
•
PostgreSQL
•
SQL Server
Expertise:
SQL
•
NoSQL
•
DQL
FAQ
Which database engines do you support?
I work with MySQL, PostgreSQL, SQL Server, and Oracle. Each order covers one database engine and version. Please confirm your engine and version before ordering.
What do you need to write or fix my query?
Please provide your table definitions, anonymized sample data, and expected output. For a query fix, also send the existing SQL and any error message. Passwords and production access credentials are not needed.
What is included in the basic package?
One SELECT query created or corrected, using up to 2 tables in one database engine. You receive a commented .sql file and a brief explanation, with delivery in 3 days and 1 revision within the agreed scope. Performance tuning, stored procedures, and data changes are not included.
