-- Solution 3.1
SELECT * 
FROM Customers 
WHERE customerage > 62;
--answer:5

-- Solution 3.2
SELECT * 
FROM Customers 
WHERE countryresidence = "United Kingdom" OR AccountManagerID = 2 -- ID 2 stands for Green
ORDER BY customerage ASC;
-- correct answer: 25


--Solution 3.3
SELECT COUNT(*) FROM Customers
WHERE CustomerEmail LIKE ('%.edu%') AND countryresidence IS NOT NULL;

--Task 3.4AccountManagers
SELECT 
	COUNT (*) AS NrOfPositions -- for unique customers will need to use distinct
FROM PortfolioAmounts
WHERE amountposition BETWEEN 2000 and 3000
    --amountposition > 2000 and amountposition <3000
--ORDER BY CustomerID