select grid.id, max(st_area(st_intersection(grid.geometry, vege.geometry)), vege.type
from vege, grid
where st_intersects(vege.geometry, grid.geometry)
group by grid.id