I will write sql queries for data extraction and business reporting
Excel Automation to Save Time in Your Business
Level 1
Has met certain performance criteria and shows strong potential in the marketplace.
About this Gig
Get documented SQL queries that return a defined business result from your existing data.
I work from your schema, metric rules and expected output to write queries you can understand and reuse.
Choose:
- 1 SELECT query using up to 3 tables
- Up to 3 reporting queries on one schema of up to 5 tables
- Up to 6 queries on one schema of up to 8 tables
Joins and aggregations are agreed in scope. CTEs or window functions are included only when needed and confirmed for the chosen database engine and version.
You receive commented SQL, an explanation of the rules and sample results where execution with authorized data is available. I check joins, NULL handling, date filters and control totals.
Server administration, migrations, production data changes, advanced tuning and dashboards are excluded. Database engines are confirmed before ordering.
Send an anonymized schema, sample rows and the output you need. Do not send passwords in the requirements form.
Database type:
Relational database
Platform:
MySQL
Expertise:
SQL
•
DQL
My Portfolio
FAQ
What database engines do you support?
The engine and version are confirmed before ordering based on a relevant example. The gig does not promise compatibility with every SQL dialect.
What do you need to write a query?
Table definitions, relationships or keys, anonymized sample rows, the business rule and the expected output. An unknown schema needs a separate discovery scope.
What counts as one query?
One defined SELECT output answering an agreed reporting need. A whole database project, application or unrelated collection of outputs is not one query.
Will you test the query?
I check the result using authorized sample data where execution is available, including joins, NULL values, date boundaries and relevant totals.
Are CTEs and window functions included?
They can be used in the agreed reporting scope when needed and supported by the confirmed engine. Complexity is assessed from the schema and expected output.
Will you change my production database?
No. These packages deliver query code and explanations. Production updates, migrations, administration and deployment are not included.
Does this include advanced performance tuning?
No. Query requirements are scoped for the agreed result. Server tuning, large-scale performance investigations and infrastructure work require a separate service.
What files will I receive?
Commented SQL scripts, a clear explanation and sample output when available. New metrics, schemas or independent queries beyond the package are additional scope.

