Looking for a MS SQL developer to Generate T-SQL queries

I need a developer or particularly an MS SQL to examine the attached data and come up with scripts and stored procedures as needed.

TASK 1

We need to update the values of the fields “TotalTays”, “TotalNights”, “FirstStay”,”LeadTime” for all the active profiles in the Core_Profile.

DP INFO
Prepare an UPDATE single query to update the indicated values.


Tables
Core_Profile
Core_Stay
Link_ProfileStay


Tips
Only “Definite” Stays should be taken into account.
LeadTime is the average time in days, between the reservation and the arrival dates.



TASK 2

We need an overview, how many profiles with stays are available, based on the last 5 years until now. (So how many profiles with stays there are from 2018 until now, how many from 2019 until now and so on)

And the same for profile without stays but with email and postal address available.

DP INFO
This is required because the client pays based on how many profiles they import, and they need to decide how many of them they import into dp.

Prepare a SELECT single query , defining how many profile there are of each kind (With stays and without stay BUT with email and postal address).

Tables
ImportTable1_DVA

Tips
You can filter the date based on the departure date.
Only “Definite” Stays should be taken into account.
Each profile should only count once for each date range.

Link to tables
https://drive.google.com/file/d/1AxXkJ8doXynInzM0APKI9HA4gVFwT0ET/view?usp=share_link