title: Selection from the table by two parameters
body: <p>There is a table, where i store information about bookings.
  It's a simple one. Has just few attr like: bookingId, personId, date and shouldBeConsidered</p>
  <p>I want to retrieve for each person booked from som period of time for last 10 days and then to include property shouldBeConsidered.</p>
  <p>For instance there were 100 bookings and 2 of those amount should be taken from db. And also, there can be person who booked 100 booking where is 0 shouldBeConsidered</p>
  <p>I've code something like this:</p>
  <pre><code>var res = await this.context.Bookings
                      .Where(x =&gt; x.DateTime &gt;= bookingsStartDateTime || x.ShouldBeConsidered)
                      .GroupBy(x =&gt; br.PId)
                      .Select(x =&gt; Dal
                      {
                          Id = br.Key,
                          TotalBookings = x.Count(),
                          BookingsIssues = x.Count(x =&gt; x.ShouldBeConsidered)
                      })
                      .ToListAsync();
  </code></pre>
  <p>But, unfortuanlly, it does not work properly. Sometimes, it could take a bit more issues and also count a bit more total.</p>