Calculated fields in MS SQL?

Question

Database

I started to study databases and came across such a thing as calculated fields in MS SQL Server. So, is it possible to make it so that, for example, having a database of negotiation bodies.
with tables (Subscribers, calls, cities, etc.) in the "calls" table there is a column "total cost of a call" (which is calculated by the duration * cost of a call to this city (rubles / min)), and the column "call cost per minute" is in the city table.
So is it possible to make sure that in each new row this column is calculated independently by taking data from other tables ...

Answer 1

Yes.