sql-tests.testcases.tpcds.q51.result Maven / Gradle / Ivy
-- delimiter: |; types: BIGINT|DATE|DECIMAL|DECIMAL|DECIMAL|DECIMAL
14|2000-01-10|176.83|null|176.83|73.60|
14|2000-01-21|null|75.29|176.83|75.29|
14|2000-01-29|222.33|null|222.33|75.29|
14|2000-02-02|224.01|null|224.01|75.29|
14|2000-02-08|null|85.07|224.01|85.07|
14|2000-02-19|null|98.60|224.01|98.60|
14|2000-02-21|241.64|null|241.64|98.60|
14|2000-02-22|null|99.83|241.64|99.83|
14|2000-03-18|null|112.82|241.64|112.82|
14|2000-03-23|251.15|null|251.15|112.82|
14|2000-03-28|260.17|null|260.17|112.82|
14|2000-03-31|370.74|null|370.74|112.82|
14|2000-04-05|null|115.94|370.74|115.94|
14|2000-04-15|445.30|null|445.30|115.94|
14|2000-04-27|null|151.48|445.30|151.48|
14|2000-05-03|null|176.89|445.30|176.89|
14|2000-05-10|451.40|null|451.40|176.89|
14|2000-05-21|null|238.39|451.40|238.39|
14|2000-05-26|596.81|null|596.81|238.39|
14|2000-05-29|null|242.51|596.81|242.51|
14|2000-06-05|null|304.64|596.81|304.64|
14|2000-07-03|623.77|null|623.77|304.64|
14|2000-07-07|null|307.77|623.77|307.77|
14|2000-07-18|null|320.04|623.77|320.04|
14|2000-07-25|673.08|null|673.08|320.04|
14|2000-08-10|null|411.48|673.08|411.48|
14|2000-08-14|null|465.85|673.08|465.85|
14|2000-08-21|null|541.45|673.08|541.45|
14|2000-08-26|null|574.56|673.08|574.56|
19|2000-01-02|56.96|49.68|56.96|49.68|
25|2000-01-21|97.29|null|97.29|4.49|
25|2000-01-28|192.46|null|192.46|4.49|
25|2000-02-09|null|24.23|192.46|24.23|
25|2000-02-11|null|98.99|192.46|98.99|
25|2000-02-21|null|170.60|192.46|170.60|
25|2000-02-22|null|185.05|192.46|185.05|
35|2000-01-14|null|55.24|177.88|55.24|
35|2000-01-16|null|95.92|177.88|95.92|
35|2000-01-18|null|126.45|177.88|126.45|
35|2000-01-19|null|167.07|177.88|167.07|
35|2000-02-17|null|173.97|177.88|173.97|
35|2000-02-22|270.43|null|270.43|173.97|
35|2000-02-23|null|180.61|270.43|180.61|
35|2000-03-03|null|181.99|270.43|181.99|
35|2000-03-05|null|221.24|270.43|221.24|
35|2000-03-06|null|266.41|270.43|266.41|
37|2000-01-02|31.75|11.89|31.75|11.89|
37|2000-01-04|null|17.15|31.75|17.15|
37|2000-01-05|34.34|null|34.34|17.15|
37|2000-01-06|null|29.67|34.34|29.67|
41|2000-01-21|null|15.54|123.34|15.54|
41|2000-02-03|null|21.04|123.34|21.04|
41|2000-02-16|null|33.46|123.34|33.46|
41|2000-02-20|null|37.46|123.34|37.46|
41|2000-02-22|null|58.57|123.34|58.57|
41|2000-03-05|null|70.06|123.34|70.06|
41|2000-03-17|178.84|150.76|178.84|150.76|
41|2000-04-26|263.14|null|263.14|254.88|
41|2000-07-12|474.83|null|474.83|393.87|
41|2000-07-18|null|421.23|474.83|421.23|
41|2000-08-15|null|430.77|474.83|430.77|
49|2000-01-18|null|2.51|4.58|2.51|
49|2000-01-31|72.47|null|72.47|13.05|
49|2000-02-13|null|70.68|72.47|70.68|
49|2000-02-29|null|71.86|72.47|71.86|
49|2000-04-17|225.29|null|225.29|219.03|
53|2000-01-02|12.85|1.13|12.85|1.13|
53|2000-01-08|119.24|null|119.24|1.13|
53|2000-01-09|126.98|null|126.98|1.13|
53|2000-01-15|null|3.20|126.98|3.20|
53|2000-02-04|null|22.89|126.98|22.89|
53|2000-02-05|null|64.45|126.98|64.45|
53|2000-02-12|null|66.06|126.98|66.06|
56|2000-01-02|41.57|17.31|41.57|17.31|
61|2000-02-17|421.60|null|421.60|344.03|
61|2000-03-01|null|411.33|421.60|411.33|
61|2000-04-22|600.20|null|600.20|573.28|
71|2000-01-02|13.92|2.88|13.92|2.88|
85|2000-02-03|null|42.30|65.50|42.30|
85|2000-02-16|null|42.95|65.50|42.95|
85|2000-04-19|335.16|null|335.16|247.67|
85|2000-04-23|null|252.83|335.16|252.83|
85|2000-05-02|null|289.65|335.16|289.65|
85|2000-05-11|null|312.62|335.16|312.62|
86|2000-01-19|31.70|null|31.70|25.97|
86|2000-02-03|151.26|null|151.26|91.16|
86|2000-02-04|null|112.15|151.26|112.15|
89|2000-01-12|null|28.84|181.56|28.84|
89|2000-01-23|null|67.19|181.56|67.19|
89|2000-01-30|null|104.65|181.56|104.65|
89|2000-02-22|null|146.96|181.56|146.96|
89|2000-02-25|null|147.02|181.56|147.02|
89|2000-03-19|null|172.85|181.56|172.85|
89|2000-03-20|191.66|null|191.66|172.85|
89|2000-04-11|295.81|null|295.81|172.85|
89|2000-04-13|null|203.86|295.81|203.86|
89|2000-04-20|373.30|null|373.30|203.86|
89|2000-04-23|null|219.74|373.30|219.74|
89|2000-04-26|null|235.97|373.30|235.97|
89|2000-05-04|null|248.05|373.30|248.05|