Transactional SQL Queries & Visuals
Budget: £10 – £20 GBP
I have a transactional database and a series of questions that need clean, efficient SELECT statements—many of them filter by dates and times. For each query I also need a clear picture: either a screenshot of the result set, an execution-plan diagram, or a quick chart if that better illustrates the outcome.
You’ll receive the schema, sample data, and the exact business questions as soon as we start. Your job is to write the queries, test them against the data I provide, and supply the companion images so I can drop everything straight into my report.
Deliverables
• A single, well-commented SQL script (or multiple files if you prefer) containing every SELECT statement.
• A set of image files—PNG or JPEG—named to match each query for easy reference.
Acceptance criteria
• Every query returns the expected rows on my side without modification.
• Screenshots or visuals are clear, readable, and correctly labelled.
I’m ready to share the database dump right away and will be available for quick clarifications so we can keep momentum.
You’ll receive the schema, sample data, and the exact business questions as soon as we start. Your job is to write the queries, test them against the data I provide, and supply the companion images so I can drop everything straight into my report.
Deliverables
• A single, well-commented SQL script (or multiple files if you prefer) containing every SELECT statement.
• A set of image files—PNG or JPEG—named to match each query for easy reference.
Acceptance criteria
• Every query returns the expected rows on my side without modification.
• Screenshots or visuals are clear, readable, and correctly labelled.
I’m ready to share the database dump right away and will be available for quick clarifications so we can keep momentum.