this is my first question here. I am very new into SQL Server and T-SQL.

I would like to create a table, with a column that is using data from another column. I thought I could use select function, but it is not allowed.

How to do it?

It is very simple to create view in this way, but I would like to have a table not view.

It should look like

```
Column A, ColumnB, 
Column C=select count(*) from [another table] where....

```

Could you please advise?