fleshed out portfolio.sql