Write 5 LINQ Queries / SQL Server scripts for a .Net C# App

To be clear...I'm looking for asp.net EF queries. These could be Raw SQL queries, but NOT LINQtoSQL. Sorry, Freelancer won't let me updated the title of the project. I have several SQL Server tables from which I need to extract data AND perform calculations on that data. The queries will need to accept a date range and another geographic constraint. The data required for each query will come from at least 2-3 different tables, so multiple JOINs are necessary. I will give you the table schema and provide the names of the columns where the data is located, I need you to write the query. For example: I will need the query to calculate and sort (desc) the % growth rate of XYZ BETWEEN two dates (input) within a certain county or MSA (input). I will need these queries built quickly. If your schedule won't permit you to work on these right away, then please don't bid.