CODEWITHSUNDEEP
mysqllaravel
Rung Ruoi
Rung Ruoi

Reputation: 59

Convert mysql query to Query Builder laravel

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');

Upvotes: 1

Views: 37

Answers (1)

TsaiKoga
TsaiKoga

Reputation: 13394

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();

Upvotes: 2

Related Questions