I can't understand why would you like to be forced to create another table for relations if you can just use smth like references in most languages. What is the point of such complexity? I would rather type:
companies.First(cmpn=>cmpn.Name="Netflix").Employees.Avg(empl=>empl.Sal)
then use relations:
select * from companies join company_employess on ... join ... group by.. avg
I found some NoSQL DBs like Couchbase and other alternatives but all the companies demand SQL-devs. Why is it the way it is? (I'm using ASP.NET 6 + Blazor)