🚀 go-pugleaf

Hello. I want to run a query on a shopping basket, and also go the count of
every duplicate record. I've got this far...
Fetches the selected items if they exist in the master productlisting.
SELECT ordre.id, ordre.kunde, ordre.varenr AS [prod], produkter.navn,
produkter.pris, produkter.innhold FROM ordre INNER JOIN produkter ON
ordre.varenr = produkter.id WHERE (((ordre.kunde)=:kunde));

Gets the total price of all items listed in the shopping-basket related to
the customer no. :kunde
SELECT DISTINCTROW ordre.kunde, Sum(ordre.pris) AS [totalsum] FROM ordre
GROUP BY ordre.kunde HAVING (((ordre.kunde)=:kunde));

How to combine these two?