sql-tests.testcases.tpcds.q18.result Maven / Gradle / Ivy
The newest version!
-- delimiter: |; types: CHAR|VARCHAR|CHAR|VARCHAR|DECIMAL|DECIMAL|DECIMAL|DECIMAL|DECIMAL|DECIMAL|DECIMAL
AAAAAAAABFBAAAAA|United States|IN|Adams County|8|86.17|0|85.30|415.20|1981|2|
AAAAAAAADMKDAAAA|United States|IN|Adams County|99|29.12|0|11.06|-562.32|1981|2|
AAAAAAAAEGDAAAAA|United States|IN|Adams County|70|51.12|0|34.25|1110.20|1981|2|
AAAAAAAAGHGAAAAA|United States|IN|Adams County|90|73.47|0|36.73|-1318.50|1981|2|
AAAAAAAAKBCBAAAA|United States|IN|Adams County|35|46.23|973|28.66|-682.85|1981|2|
AAAAAAAACCJAAAAA|United States|IN|Cass County|67|55.73|679.48|36.22|-14.17|1972|1|
AAAAAAAACIMBAAAA|United States|IN|Cass County|51|21.90|294.86|17.52|-86.78|1972|1|
AAAAAAAADJPBAAAA|United States|IN|Cass County|88|51.59|0|49.01|2697.20|1972|1|
AAAAAAAAHJDDAAAA|United States|IN|Cass County|77|38.31|0|32.94|-300.30|1972|1|
AAAAAAAANFAEAAAA|United States|IN|Cass County|46|110.69|0|47.59|-1474.30|1972|1|
AAAAAAAAOLJDAAAA|United States|IN|Cass County|59|239.30|0|50.25|-2918.14|1972|1|
AAAAAAAACEGCAAAA|United States|IN|Clark County|42|24.85|0|13.66|-188.16|1975|3|
AAAAAAAACLPDAAAA|United States|IN|Clark County|1|61.08|0|0.61|-23.16|1975|3|
AAAAAAAAGLDAAAAA|United States|IN|Clark County|11|204.81|0|12.28|-963.93|1975|3|
AAAAAAAAJPKAAAAA|United States|IN|Clark County|52|11.51|201.45|5.87|-240.45|1975|3|
AAAAAAAALJCDAAAA|United States|IN|Clark County|83|101.54|684.18|29.44|-3002.37|1975|3|
AAAAAAAACLICAAAA|United States|IN|Crawford County|51|126.57|0|78.47|1663.11|1930|4|
AAAAAAAAJEDAAAAA|United States|IN|Crawford County|83|78.26|6237.52|75.91|-5952|1930|4|
AAAAAAAALJFAAAAA|United States|IN|Crawford County|82|94.10|0|34.81|-4637.10|1930|4|
AAAAAAAAODJAAAAA|United States|IN|Crawford County|49|151.09|0|15.10|-2198.14|1930|4|
AAAAAAAAOPBBAAAA|United States|IN|Crawford County|73|162.05|0|71.30|839.50|1930|4|
AAAAAAAAAGCDAAAA|United States|IN|De Kalb County|15|33.56|0|29.53|191.25|1963|5|
AAAAAAAAALBCAAAA|United States|IN|De Kalb County|3|43.18|0|5.18|-39.12|1963|5|
AAAAAAAACICCAAAA|United States|IN|De Kalb County|62|111.50|0|66.90|-1050.28|1963|5|
AAAAAAAADFIDAAAA|United States|IN|De Kalb County|75|277.95|0|150.09|3811.50|1963|5|
AAAAAAAAGDDBAAAA|United States|IN|De Kalb County|17|102.12|0|30.63|-438.43|1963|5|
AAAAAAAAGDDCAAAA|United States|IN|De Kalb County|72|7.99|404.35|7.91|-58.75|1963|5|
AAAAAAAAIHLCAAAA|United States|IN|De Kalb County|76|234.20|0|201.41|8271.84|1963|5|
AAAAAAAAILCBAAAA|United States|IN|De Kalb County|92|87.33|0|3.49|-2781.16|1963|5|
AAAAAAAAJIDCAAAA|United States|IN|De Kalb County|1|82.20|0|62.47|-4.36|1963|5|
AAAAAAAAACBCAAAA|United States|IN|Dearborn County|1|77.53|0|49.61|-1.40|1982|0|
AAAAAAAACOHCAAAA|United States|IN|Dearborn County|53|76.54|258.73|22.19|-2407.88|1982|0|
AAAAAAAAFBBAAAAA|United States|IN|Dearborn County|66|121.25|0|54.56|-524.04|1982|0|
AAAAAAAAFIBCAAAA|United States|IN|Dearborn County|26|38.28|0|25.64|222.30|1982|0|
AAAAAAAAILEDAAAA|United States|IN|Dearborn County|96|213.31|491.32|17.06|-7995.64|1982|0|
AAAAAAAAKIKDAAAA|United States|IN|Dearborn County|96|168.66|0|123.12|4840.32|1982|0|
AAAAAAAAKPEDAAAA|United States|IN|Dearborn County|1|103.55|10.25|93.19|40.15|1982|0|
AAAAAAAAMFKBAAAA|United States|IN|Dearborn County|79|98.01|0|81.34|2217.53|1982|0|
AAAAAAAAMFOBAAAA|United States|IN|Dearborn County|10|203.77|90.06|52.98|-293.26|1982|0|
AAAAAAAAMLIBAAAA|United States|IN|Dearborn County|37|48.54|0|0|-1350.50|1982|0|
AAAAAAAAMOIAAAAA|United States|IN|Dearborn County|60|173.07|1623.98|58.84|-1578.38|1982|0|
AAAAAAAAONBAAAAA|United States|IN|Dearborn County|14|17.24|0|1.37|-114.24|1982|0|
AAAAAAAAPFEBAAAA|United States|IN|Dearborn County|35|141.77|0|89.31|920.50|1982|0|
AAAAAAAAAEJBAAAA|United States|IN|Fayette County|76|85.66|0|17.13|-4670.96|1985|2|
AAAAAAAAALIBAAAA|United States|IN|Fayette County|53|170.42|3689.47|161.89|-45.19|1985|2|
AAAAAAAACDADAAAA|United States|IN|Fayette County|43|45.12|0|34.29|774|1985|2|
AAAAAAAADKDAAAAA|United States|IN|Fayette County|75|40.58|0|38.14|606|1985|2|
AAAAAAAAGCBCAAAA|United States|IN|Fayette County|50|118.21|648.90|72.10|-1849.40|1985|2|
AAAAAAAAGKOBAAAA|United States|IN|Fayette County|2|85.08|0|45.09|-42.76|1985|2|
AAAAAAAAGMLAAAAA|United States|IN|Fayette County|7|28.73|0|24.42|62.79|1985|2|
AAAAAAAAKNODAAAA|United States|IN|Fayette County|97|153.25|227.41|78.15|-554.30|1985|2|
AAAAAAAAKOPBAAAA|United States|IN|Fayette County|28|67.69|1021.31|37.22|-1520.27|1985|2|
AAAAAAAAMJJCAAAA|United States|IN|Fayette County|67|25.67|0|21.81|775.86|1985|2|
AAAAAAAANAHCAAAA|United States|IN|Fayette County|55|45.89|368.94|7.80|-844.69|1985|2|
AAAAAAAAAOFDAAAA|United States|IN|Fountain County|87|28.71|0|27.84|1472.04|1968|6|
AAAAAAAACCGBAAAA|United States|IN|Fountain County|85|44.48|0|30.24|15.30|1968|6|
AAAAAAAAIIADAAAA|United States|IN|Fountain County|78|118.17|0|115.80|3411.72|1968|6|
AAAAAAAAOBDBAAAA|United States|IN|Fountain County|65|188.63|0|165.99|5481.45|1968|6|
AAAAAAAAAEABAAAA|United States|IN|Hamilton County|32|29.89|0|28.39|391.36|1932|5|
AAAAAAAAAEFCAAAA|United States|IN|Hamilton County|32|31.97|0|18.54|65.92|1932|5|
AAAAAAAAAMNDAAAA|United States|IN|Hamilton County|70|101.27|4284.88|65.82|-4341.58|1932|5|
AAAAAAAAEPKCAAAA|United States|IN|Hamilton County|35|128.90|0|105.69|2021.95|1932|5|
AAAAAAAAGIMAAAAA|United States|IN|Hamilton County|79|12.06|326.71|8.44|-118.15|1932|5|
AAAAAAAAGKFBAAAA|United States|IN|Hamilton County|43|23.85|0|0.95|-580.93|1932|5|
AAAAAAAAIFICAAAA|United States|IN|Hamilton County|86|2.45|0|1.98|48.16|1932|5|
AAAAAAAACHNDAAAA|United States|IN|Jennings County|36|2.87|0|0.11|-49.32|1958|2|
AAAAAAAADBECAAAA|United States|IN|Jennings County|59|89.31|775.52|57.15|747.27|1958|2|
AAAAAAAAIAHBAAAA|United States|IN|Jennings County|2|42.43|0|22.06|-12.46|1958|2|
AAAAAAAAICDEAAAA|United States|IN|Jennings County|17|146.85|0|41.11|-524.96|1958|2|
AAAAAAAANDMAAAAA|United States|IN|Jennings County|32|238|637.45|21.42|-2870.09|1958|2|
AAAAAAAAPNBCAAAA|United States|IN|Jennings County|59|230.88|0|223.95|7465.27|1958|2|
AAAAAAAAAICBAAAA|United States|IN|Johnson County|59|156.86|0|37.64|-1144.60|1924|2|
AAAAAAAACGJAAAAA|United States|IN|Johnson County|41|111.54|0|72.50|1333.32|1924|2|
AAAAAAAAHNPCAAAA|United States|IN|Johnson County|5|229.9|885.99|188.51|-432.59|1924|2|
AAAAAAAAKBBCAAAA|United States|IN|Johnson County|80|105.66|0|73.96|-344.80|1924|2|
AAAAAAAAKMEDAAAA|United States|IN|Johnson County|11|81.28|0|27.63|-343.97|1924|2|
AAAAAAAAKNCEAAAA|United States|IN|Johnson County|68|100.51|0|18.09|-4713.08|1924|2|
AAAAAAAADAEDAAAA|United States|IN|Kosciusko County|84|68.84|464.19|7.57|-2622.15|1987|1|
AAAAAAAAENDAAAAA|United States|IN|Kosciusko County|99|142.12|679.55|98.06|3855.64|1987|1|
AAAAAAAAHHFAAAAA|United States|IN|Kosciusko County|59|74.54|0|64.84|2237.87|1987|1|
AAAAAAAAHKHBAAAA|United States|IN|Kosciusko County|16|58.2|0|27.35|-97.60|1987|1|
AAAAAAAAIFBCAAAA|United States|IN|Kosciusko County|44|69.88|0|69.88|1464.76|1987|1|
AAAAAAAAKCLDAAAA|United States|IN|Kosciusko County|53|171.98|0|29.23|-1997.57|1987|1|
AAAAAAAAKHCEAAAA|United States|IN|Kosciusko County|75|62.04|0|32.88|369.75|1987|1|
AAAAAAAALOFBAAAA|United States|IN|Kosciusko County|49|95.19|0|77.10|2135.42|1987|1|
AAAAAAAAMMIAAAAA|United States|IN|Kosciusko County|56|12.78|0|12.01|345.52|1987|1|
AAAAAAAAPHADAAAA|United States|IN|Kosciusko County|19|89.15|0|1.78|-638.40|1987|1|
AAAAAAAAAJAEAAAA|United States|IN|La Porte County|56|84.85|0|6.78|-2990.40|1975|4|
AAAAAAAAALCBAAAA|United States|IN|La Porte County|61|80.16|0|26.45|-1646.39|1975|4|
AAAAAAAACDDCAAAA|United States|IN|La Porte County|31|129.15|0|38.74|-1182.34|1975|4|
AAAAAAAACDPDAAAA|United States|IN|La Porte County|23|54.41|282.09|22.30|-343.27|1975|4|
AAAAAAAADFEEAAAA|United States|IN|La Porte County|52|126.01|0|41.58|-829.92|1975|4|
AAAAAAAAEPJDAAAA|United States|IN|La Porte County|38|63.13|0|46.08|859.18|1975|4|
AAAAAAAAIEDBAAAA|United States|IN|La Porte County|13|50.53|0|31.32|-52.26|1975|4|
AAAAAAAAIOAEAAAA|United States|IN|La Porte County|10|53.35|0|33.07|122.30|1975|4|
AAAAAAAAJKMAAAAA|United States|IN|La Porte County|50|66.92|0|16.73|-749.50|1975|4|
AAAAAAAAKDBAAAAA|United States|IN|La Porte County|57|123.53|0|81.52|959.88|1975|4|
AAAAAAAAKIDBAAAA|United States|IN|La Porte County|38|50.2|0|40.66|-307.04|1975|4|
AAAAAAAALHDEAAAA|United States|IN|La Porte County|72|147.38|0|26.52|-3985.92|1975|4|
AAAAAAAALKEAAAAA|United States|IN|La Porte County|68|159.12|0|77.96|-709.92|1975|4|