orderBy relatable table

if you only have 2 tables, then what is 'C'?

is everything limited to 2-digits? What if you have more than 99 sales?

this question is flawed - can you be a little more clear?

I mean ABC is the name of products

and the tables are only products and sales, and I just wanna know how to sort by best selling products

i think you need to get all sales joined with products (to get the name), grouped by product.id and you need to have a group count as total_sale, then you order by this one desc.

Something like:

Sales::select(\DB::raw('COUNT(sales.id) as total_sales, products.name'))
    ->with('product')
    ->orderBy(\DB::raw('COUNT(sales.id)', 'desc')
    ->groupBy('product.id)
    ->get();

(not tested)

Another alternative - using Eloquent and collections might go:

Product::has('sales')
    ->get()
    ->sortByDesc(function ($p) {
        return $p->sales->count();
    });

assuming you have your Product model setup correctly with the sales()