I am looking for a good laravel developer for 5-6 database queries

I need your help with querys problem, your task is to write the database queries and prepare the data to be output as in the example. In my table(posts) the published posts will be saved. Columns: id, user_id,type, created_at, status and other... In the column type the different types are stored by numbers (1-9), in the column created_at it looks like this 2019-12-08 20:02:06 Now I need a graphical overview of the different posttypes at the different times for every time, one output. i will then load the data into the morrisjs chart via ajax. Times: weekly overview(last 7 days), monthly overview(last 30 days), yearly overview(last 12 months), daily overview(last 24h). example output: data: [{ period: 'date/time', 1: 4912, 2: 4912, 3: 4712, 4: 5912, 5: 7912, 6: 9912, 7: 4212, 8: 1912, 9: 8912, }, { period: 'date/time', 1: 4912, 2: 4912, 3: 4712, 4: 5912, 5: 7912, 6: 9912, 7: 4212, 8: 1912, 9: 8912, }, { period: 'date/time', 1: 4912, 2: 4912, 3: 4712, 4: 5912, 5: 7912, 6: 9912, 7: 4212, 8: 1912, 9: 8912, }, }],