SELECT
	c.customerid,
    c.customer,
    pa.AmountPosition, 
    pp.PositionType, 
    pp.PortfolioPosition, 
    pp.StockType
FROM Customers AS C
LEFT JOIN PortfolioAmounts AS pa
	ON c.CustomerID = pa.customerid
LEFT JOIN PortfolioPositions AS pp
	ON pa.PortfolioPositionsID = pp.PortfolioPositionsID
WHERE pp.stocktype = 'IPO'
-- WHERE pp.positiontype = 'Cash Remaining'
ORDER BY pa.amountposition DESC;

SELECT
    sum(pa.AmountPosition)
FROM Customers AS C
LEFT JOIN PortfolioAmounts AS pa
	ON c.CustomerID = pa.customerid
LEFT JOIN PortfolioPositions AS pp
	ON pa.PortfolioPositionsID = pp.PortfolioPositionsID
WHERE pp.stocktype = 'IPO'
-- WHERE pp.positiontype = 'Cash Remaining'
ORDER BY pa.amountposition DESC;

SELECT
   count(c.customerid)
FROM Customers AS C
LEFT JOIN PortfolioAmounts AS pa
	ON c.CustomerID = pa.customerid
LEFT JOIN PortfolioPositions AS pp
	ON pa.PortfolioPositionsID = pp.PortfolioPositionsID
WHERE pp.positiontype = 'Cash Remaining'
ORDER BY pa.amountposition DESC;