I don't know how to convert subquery to laravel query. How I can convert mysql query to laravel query? this is the query
select vd_id, subCount
from (select vd_id, count(vd_id) subCount
from sell_data
group by vd_id) sub
where subCount = (select count(vd_id) maxCount
from sell_data
group by vd_id
order by maxCount desc limit 1)
or subCount = (select count(vd_id) minCount
from sell_data
group by vd_id
order by minCount asc limit 1) ;