fyaconiello

SELECT

            SUM(p_tmhh.holding_pct * (s_sach.percentage / 100)) AS percentage
            FROM
            portfolio_trademodelholdinghistory AS p_tmhh
            INNER JOIN security_datedim AS s_dd ON s_dd.id = p_tmhh.holding_date_id
            INNER JOIN security_securityassetclasshistory s_sach ON s_sach.month_id = s_dd.month_id
            AND s_sach.security_id = p_tmhh.security_id
            INNER JOIN security_securitybreakdowntype AS s_sbt ON s_sbt.id = s_sach.securitybreakdowntype_id
            INNER JOIN portfolio_investmentoffering AS p_io ON p_tmhh.trade_model_id = p_io.trade_model_id

fyaconiello

Step 1 - download and install macosx pkgs

• download and install xcode
• XCode and enable Command Line Tools
• download and install mysql-server

Step 2

nano ~/.bash_profile

add the following