Laravel, Google Data Studio

I have 3 tables that I need to extract meaningful data from and put in charts; Grouped By: School_code, payrolls.school_code, [login to view URL], payrolls.work_area, payrolls.full_name, payrolls.st_hours, payrolls.st_rate, payrolls.ot_hours, payrolls.ot_rate, payrolls.pay_code, payrolls.punch_in, payrolls.punch_out, [login to view URL], attendances.school_code, [login to view URL], attendances.child_count, students.school_code, students.primary_classroom, students.date_of_birth, students.primary_classroom == payrolls.work_area (except for work areas where there are no students //kitchen, office) examples of needed -> for each payrolls by school_code, department: "(st_hours * st_rate)+(ot_hours * ot_rate)"; need to get $ / student; --- can you work with JSON stored in longtext ? *** at the very least, I need help creating a View in MySQL to reference elsewhere. - looking also for laravel + jquery assistance