On Tuesday, January 1, 2019, David G. Johnston <
david.g.johnston@gmail.com> wrote:
On Tuesday, January 1, 2019, Chuck Martin <clmartin@theombudsman.com> wrote:
results wanted-all transactions where account total >= 50
id. amount. accountid. name
1. 50. 1 bill
3. 75. 1 bill
4 25. 1 bill
5 50 3 sarah
This result does not require group by, just the where clause you’ve noted above.
Never mind...missed how the 25 got included
David J.