GENRE_SUB_NAME IN ( SELECT GENRE_SUB_NAME FROM ( SELECT GENRE_SUB_NAME, ROW_NUMBER() OVER (ORDER BY OPEN_DATE) AS ROW_NUM FROM FOOD_ESTABLISHMENTS_DATA_SET_IN_JAPAN.MART.FOOD_SAMPLE_OSAKA_CHUO ) AS SUB_QUERY WHERE ROW_NUM <= 10 ) ORDER BY OPEN_DATE; ``` Here is generated SQL: SELECT * FROM FOOD_ESTABLISHMENTS_DATA_SET_IN_JAPAN.MART.FOOD_SAMPLE_OSAKA_CHUO ORDER BY OPEN_DATE; 2025 truestar inc. All Rights Reserved.