SQL questions

$1.$ Replace the ids in the same report with the company name and employee name.

$2.$ Show how many shipments to each location in each year and the average freight cost by year. Order by location and year.