1SELECT 
2    d.date,
3    COALESCE(CASE WHEN d.close < d.open * 0.95 THEN ((d.close - d.open) / d.open) * 100 END, 0) AS dax_percentage_change,
4    COALESCE(CASE WHEN n.close < n.open * 0.95 THEN ((n.close - n.open) / n.open) * 100 END, 0) AS nasdaq_percentage_change,
5    COALESCE(CASE WHEN c.close < c.open * 0.95 THEN ((c.close - c.open) / c.open) * 100 END, 0) AS cac_percentage_change,
6    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,
7    COALESCE(CASE WHEN f.close < f.open * 0.95 THEN ((f.close - f.open) / f.open) * 100 END, 0) AS ftse_percentage_change,
8    COALESCE(CASE WHEN hs.close < hs.open * 0.95 THEN ((hs.close - hs.open) / hs.open) * 100 END, 0) AS hang_seng_percentage_change,
9    COALESCE(CASE WHEN k.close < k.open * 0.95 THEN ((k.close - k.open) / k.open) * 100 END, 0) AS kospi_percentage_change,
10    COALESCE(CASE WHEN nf.close < nf.open * 0.95 THEN ((nf.close - nf.open) / nf.open) * 100 END, 0) AS nifty50_percentage_change,
11    COALESCE(CASE WHEN nk.close < nk.open * 0.95 THEN ((nk.close - nk.open) / nk.open) * 100 END, 0) AS nikkei225_percentage_change,
12    COALESCE(CASE WHEN s.close < s.open * 0.95 THEN ((s.close - s.open) / s.open) * 100 END, 0) AS sse_percentage_change
13FROM "@kaggle.rohitktiwari04_top_10_stock_indices.dax" d
14LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.nasdaq" n ON d.date = n.date
15LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.cac" c ON d.date = c.date
16LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.dow_jones" dj ON d.date = dj.date
17LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.ftse" f ON d.date = f.date
18LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.hang_seng" hs ON d.date = hs.date
19LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.kospi" k ON d.date = k.date
20LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.nifty50" nf ON d.date = nf.date
21LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.nikkei_225" nk ON d.date = nk.date
22LEFT JOIN "@kaggle.rohitktiwari04_top_10_stock_indices.sse" s ON d.date = s.date
23WHERE NOT (
24    COALESCE(CASE WHEN d.close < d.open * 0.95 THEN ((d.close - d.open) / d.open) * 100 END, 0) = 0 AND
25    COALESCE(CASE WHEN n.close < n.open * 0.95 THEN ((n.close - n.open) / n.open) * 100 END, 0) = 0 AND
26    COALESCE(CASE WHEN c.close < c.open * 0.95 THEN ((c.close - c.open) / c.open) * 100 END, 0) = 0 AND
27    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
28    COALESCE(CASE WHEN f.close < f.open * 0.95 THEN ((f.close - f.open) / f.open) * 100 END, 0) = 0 AND
29    COALESCE(CASE WHEN hs.close < hs.open * 0.95 THEN ((hs.close - hs.open) / hs.open) * 100 END, 0) = 0 AND
30    COALESCE(CASE WHEN k.close < k.open * 0.95 THEN ((k.close - k.open) / k.open) * 100 END, 0) = 0 AND
31    COALESCE(CASE WHEN nf.close < nf.open * 0.95 THEN ((nf.close - nf.open) / nf.open) * 100 END, 0) = 0 AND
32    COALESCE(CASE WHEN nk.close < nk.open * 0.95 THEN ((nk.close - nk.open) / nk.open) * 100 END, 0) = 0 AND
33    COALESCE(CASE WHEN s.close < s.open * 0.95 THEN ((s.close - s.open) / s.open) * 100 END, 0) = 0
34)
35ORDER BY d.date ASC