Question: I need to count the courses in the row manner. It means college name after course are add in a one row 

```
College_name    course_name1   course_name2    course_name3    course_name4 
----------------------------------------------------------------------------
ABC College     computer       bca             cdb  
xbc college     acvb           bca             ads             abc
xdb college     cgd            ghdg           
vvv college     anb            abd             bca

```

I need a result format like this in SQL. I need to count the courses:

```
College_name      course_count 
------------------------------
ABC College          3
xbc college          4
xdb college          2     
vvv college          3

```

Answer: 
You created the wrong project type. You created a `.Net Standard Class Library`

[![enter image description here](https://i.stack.imgur.com/L24RP.png)](https://i.stack.imgur.com/L24RP.png)

but you need to create a normal `Class Library` under `Windows Desktop` in the new project template

[![enter image description here](https://i.stack.imgur.com/Rfonx.png)](https://i.stack.imgur.com/Rfonx.png)
[![enter image description here](https://i.stack.imgur.com/93V7c.png)](https://i.stack.imgur.com/93V7c.png)

Find this in your apps and features menu and try to uninstall. Then install it back and take a look what you got.