如果要查询从当前日期起10年后的数据，可以使用：

WHERE a.transaction_date <= date_sub(curdate(), interval 10 year)

这将给你所有的交易10年前，但仍然没有显示你的第一次。为此，您将需要一个子查询来按executive查找特定的数据。

SELECT filer_id,min(transaction_date) AS first_time
FROM fact_insider_sales
WHERE transaction_date <= date_sub(curdate(), interval 10 year)
GROUP BY filer_id

现在将此查询作为表包含在原始查询中：

SELECT 
e.stock_name,     
e.stock_id,
f.ticker_id,
f.ticker_name,
a.transaction_date,
d.filer_name,
b.relationship_name,
b.relationship_id
FROM fact_insider_sales as a
JOIN (SELECT filer_id,min(transaction_date) AS first_time
    FROM fact_insider_sales
    WHERE transaction_date <= date_sub(curdate(), interval 10 year)
    GROUP BY filer_id) AS p
  ON a.filer_id=p.filer_id
JOIN dim_relationship as b ON (a.relationship_id = b.relationship_id)
JOIN dim_filer as d on (a.filer_id = d.filer_id)
JOIN dim_stock as e on (a.stock_id = e.stock_id)
JOIN dim_ticker as f ON (a.ticker_id = f.ticker_id)
WHERE a.transaction_date = p.first_time
AND b.relationship_name IN ('CEO', 'CB')

使用此查询，您可以像我的示例中那样从中创建一个视图，也可以简单地将查询加入到 FROM 条款：
单击此处查看dbfiddle示例
创建列出每个 filer_id 出售，以及与下一个最老的 transaction_date 为了这个 filer_id :

CREATE VIEW sales_date_diff AS
SELECT  f1.id, 
        f1.filer_id, 
        f1.transaction_date AS transaction_date1, 
        MAX(f2.transaction_date) AS transaction_date2, 
        TIMESTAMPDIFF(YEAR, MAX(f2.transaction_date), f1.transaction_date) AS year_diff
FROM    fact_insider_sales f1
        LEFT JOIN fact_insider_sales f2
            ON f1.filer_id = f2.filer_id
            AND f2.transaction_date < f1.transaction_date
GROUP BY f1.id, f1.filer_id, f1.transaction_date;

然后在查询中加入视图，只需选择 id 在哪里 year_diff is>=10年：

SELECT 
e.stock_name,     
e.stock_id,
f.ticker_id,
f.ticker_name,
a.transaction_date,
d.filer_name,
b.relationship_name,
b.relationship_id
FROM fact_insider_sales as a 
join dim_relationship as b ON (a.relationship_id = b.relationship_id)
join dim_filer as d on (a.filer_id = d.filer_id)
join dim_stock as e on (a.stock_id = e.stock_id)
join dim_ticker as f ON (a.ticker_id = f.ticker_id)
JOIN sales_date_diff s ON a.id = s.id
WHERE s.year_diff >= 10
and b.relationship_name IN ('CEO', 'CB')