Supabase query
Hi I would like to write this sql query in my api but im unsure as to how to convert it
select categories.id, categories.category, categories.image_name, count(item.category_id)
from categories
left join item
on categories.id = item.category_id
group by item.category_id, categories.category , categories.image_name, categories.id
order by categories.id asc
