I have a small number (10) of SQL queries to be written. My knowledge of SQL is basic so I need assistance.
All the queries are against a single SQL Server 2005 database table and I have full documentation of all the columns and permitted values.
To give an idea of a typical query, each record will have an associated "time created" column. I need a count of how many records were generated, on average, per hour for the most recent 24 hours.
It's a little more involved than that, but the essence of the project is the [login to view URL] fact, 4 out of the 10 queries are very similar to the above, but with differing time intervals (per 15 minutes, per 30 minutes, per 60 minutes and per day over the most recent calendar month.
Attached is a spreadsheet detailing the queries. Once I have selected who will deliver the project I will make the full table definition and sample data available.
Finally, I want to make it totally clear that all copyright, intellectual property, source code etc etc is owned by myself, not the contractor, at the end of the assignment.