Is there anything wrong with my data model . Help with set expression !

[shekhar_analyti]

Hi All ,

I want to find number of records (matchid) where toss_winner team is game winner ONLY IN FINALS .

But i think i am getting wrong data . Is this due to wrong data model or wrong expression .

Thanks & Regards

Shekar

[sunny_talwar]

Is this what you want?

[shekhar_analyti]

exactly 100 %

[shekhar_analyti]

stalwar1‌

I same tabular column which you shared how to get Player of match in one column and Team to which player of match belongs to ... Using existing data model ... That will precisely help me in getting if my data model is correct ....

And I really  dont know  how to mark this reply as Important like mails.........

[sunny_talwar]

Just two columns? Player of the match and Team? Do you need it next to the match_id?

[shekhar_analyti]

Yes .

Actually table Player is created by me from data in table Match Stat .

[shekhar_analyti]

these two will be additional columns

[sunny_talwar]

Is this the goal?

[shekhar_analyti]

YEAH ..... Just needed only for finals though !  

[sunny_talwar]

Here you are

[shekhar_analyti]

Is there anything in that you cant answer ....