Convert mysql query to Query Builder laravel

Question

I want to convert mysql it to laravel code

SELECT *,AVG(number_star) FROM rates GROUP BY user_be_rate_id

I tried but they didn't work

Rate::all()->groupBy('user_be_rate_id')->avg('number_star');
or
Rate::->avg('number_star')->groupBy('user_be_rate_id');

TsaiKoga · Accepted Answer · 2020-01-10 06:28:42Z

2

Use selectRaw or select(DB::raw()) like this:

Rate::groupBy('user_be_rate_id')->selectRaw('*, AVG(number_star')->get();

Rate::groupBy('user_be_rate_id')->select('*', DB::raw('AVG(number_star)')->get();

answered Jan 10, 2020 at 6:28

TsaiKoga

13.4k2 gold badges23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1