SELECT 
    d.date,
    COALESCE(CASE WHEN d.close < d.open * 0.95 THEN ((d.close - d.open) / d.open) * 100 END, 0) AS dax_percentage_change,
    COALESCE(CASE WHEN n.close < n.open * 0.95 THEN ((n.close - n.open) / n.open) * 100 END, 0) AS nasdaq_percentage_change,
    COALESCE(CASE WHEN c.close < c.open * 0.95 THEN ((c.close - c.open) / c.open) * 100 END, 0) AS cac_percentage_change,
    COALESCE(CASE WHEN dj.n__close < dj.n__open * 0.95 THEN ((dj.n__close - dj.n__open) / dj.n__open) * 100 END, 0) AS dow_jones_percentage_change,
    COALESCE(CASE WHEN f.close < f.open * 0.95 THEN ((f.close - f.open) / f.open) * 100 END, 0) AS ftse_percentage_change,
    COALESCE(CASE WHEN hs.close < hs.open * 0.95 THEN ((hs.close - hs.open) / hs.open) * 100 END, 0) AS hang_seng_percentage_change,
    COALESCE(CASE WHEN k.close < k.open * 0.95 THEN ((k.close - k.open) / k.open) * 100 END, 0) AS kospi_percentage_change,
    COALESCE(CASE WHEN nf.close < nf.open * 0.95 THEN ((nf.close - nf.open) / nf.open) * 100 END, 0) AS nifty50_percentage_change,
    COALESCE(CASE WHEN nk.close < nk.open * 0.95 THEN ((nk.close - nk.open) / nk.open) * 100 END, 0) AS nikkei225_percentage_change,
    COALESCE(CASE WHEN s.close < s.open * 0.95 THEN ((s.close - s.open) / s.open) * 100 END, 0) AS sse_percentage_change
FROM "@kaggle.rohitktiwari04_top_10_stock_indices.dax" d
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.nasdaq" n ON d.date = n.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.cac" c ON d.date = c.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.dow_jones" dj ON d.date = dj.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.ftse" f ON d.date = f.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.hang_seng" hs ON d.date = hs.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.kospi" k ON d.date = k.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.nifty50" nf ON d.date = nf.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.nikkei_225" nk ON d.date = nk.date
LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.sse" s ON d.date = s.date
WHERE NOT (
    COALESCE(CASE WHEN d.close < d.open * 0.95 THEN ((d.close - d.open) / d.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN n.close < n.open * 0.95 THEN ((n.close - n.open) / n.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN c.close < c.open * 0.95 THEN ((c.close - c.open) / c.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN dj.n__close < dj.n__open * 0.95 THEN ((dj.n__close - dj.n__open) / dj.n__open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN f.close < f.open * 0.95 THEN ((f.close - f.open) / f.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN hs.close < hs.open * 0.95 THEN ((hs.close - hs.open) / hs.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN k.close < k.open * 0.95 THEN ((k.close - k.open) / k.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN nf.close < nf.open * 0.95 THEN ((nf.close - nf.open) / nf.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN nk.close < nk.open * 0.95 THEN ((nk.close - nk.open) / nk.open) * 100 END, 0) = 0 AND
    COALESCE(CASE WHEN s.close < s.open * 0.95 THEN ((s.close - s.open) / s.open) * 100 END, 0) = 0
)
ORDER BY d.date ASC