Linq data structuring -

i have 2 issues i'm struggling linq. appreciate if advise. have 2 lists rawstates (storing rows of entity-downtime-uptime-eventtype) , rawdata list storing products' in , out times entity.

1. i want select elements rawstates occurred when still waiting entity processed

   foreach(var t in rawdata)     var s = rawstates     //i not sure if single logic clause in enough;     .where(o => o.entity == t.entity         && o.downdate > t.intime         && o.update < t.outtime)     .tolist(); 

2. if group rawdata productid (there multiple rows same productid), how can revert "s" these groups productid can group eventtype, , summarise durations productid?