I have two tables Company and CompanyLike
CompanyLike
Id
RatingStar
Count
Companyid
Company and CompanyLike have 1 to Many relation . One company can have many likes
Company Like Table Will Look Like this
+----------------------------+
| ID RatingStar Companyid |
+----------------------------+
| 1 5 5636 |
| 2 5 5636 |
| 3 1 101 |
| 4 2 959 |
+----------------------------+
Now i want to get count of rating star that how many times RatingStar is 5 , and how many time its 2 against every Companyid
I want my result like this
+-------------------------------------------------------------------------------------------+
| ID Companyid RatingStar1 RatingStar2 RatingStar3 RatingStar4 RatingStar5 |
+-------------------------------------------------------------------------------------------+
| 1 5636 0 0 0 0 2 |
| 1 101 0 0 0 0 0 |
| 1 959 1 1 0 0 0 |
+-------------------------------------------------------------------------------------------+
How to do this ?
[edit]Code block added - OriginalGriff[/edit]