Adding a DISTINCT COUNT column in table to an INNER JOIN query in SQLite: A Subquery Solution

Solving the LineItem Issue in SQL with Proper Grouping of OrderLine Elements