I want to run a pull that counts the UNITS from a MEMBER and only show the rows where the member passes 6 in units. (So everything after 6 units would get pulled based on the date). Every month the member is only allowed to buy 6 in quantity. How do I pull the only LOGS where the member exceeded 6 units?

The units in the where clause will not pull the recent rows after the 6th quantity is passed.

```
Select *
from LogTable where [item] in ('Candy','drinks','meat')
and [units] > 6  ;

```

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