You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-11-03 17:13:17 +03:00
4c9d6e39ac
* Restructured test suites and added autopilot and extended suites * Updated autopilot with correct branch - develop * Moved setup test case to a 'setup' directory, for consistency * Fixed a path issue * Updated some tests cases to keep up with development Co-authored-by: root <root@rocky8.localdomain>
100 lines
6.3 KiB
Plaintext
100 lines
6.3 KiB
Plaintext
USE ssb1;
|
|
select c_name, d_month, sum(lo_extendedprice), min(lo_orderdate), max(lo_orderdate) from lineorder join customer on lo_custkey = c_custkey join dateinfo on lo_orderdate = d_datekey where lo_orderdate between 19970101 and 19971230 and lo_custkey in ( select lo_custkey from (select lo_custkey, sum(lo_extendedprice) from lineorder where lo_orderdate between 19971201 and 19971230 group by 1 order by 2 desc limit 10 ) a ) group by 1,2 order by 1,2;
|
|
c_name d_month sum(lo_extendedprice) min(lo_orderdate) max(lo_orderdate)
|
|
Customer#000004069 April 21125678.00 19970419 19970419
|
|
Customer#000004069 Augest 20575825.00 19970827 19970827
|
|
Customer#000004069 December 113152144.00 19971204 19971218
|
|
Customer#000004069 February 8978034.00 19970221 19970221
|
|
Customer#000004069 January 11268406.00 19970111 19970125
|
|
Customer#000004069 July 7124434.00 19970716 19970716
|
|
Customer#000004069 June 19457631.00 19970612 19970612
|
|
Customer#000004069 March 9009729.00 19970303 19970303
|
|
Customer#000004069 May 70678616.00 19970509 19970519
|
|
Customer#000004069 November 38789361.00 19971105 19971113
|
|
Customer#000004069 Octorber 29258802.00 19971016 19971027
|
|
Customer#000004069 September 14125002.00 19970904 19970916
|
|
Customer#000005044 April 11564240.00 19970414 19970422
|
|
Customer#000005044 Augest 45510875.00 19970811 19970820
|
|
Customer#000005044 December 125177116.00 19971213 19971224
|
|
Customer#000005044 February 6175292.00 19970226 19970226
|
|
Customer#000005044 January 3621912.00 19970119 19970119
|
|
Customer#000005044 July 38067273.00 19970702 19970728
|
|
Customer#000005044 June 23521471.00 19970602 19970620
|
|
Customer#000005044 May 64822910.00 19970513 19970530
|
|
Customer#000005044 November 26601914.00 19971123 19971124
|
|
Customer#000005044 Octorber 22654964.00 19971014 19971031
|
|
Customer#000005044 September 40649108.00 19970923 19970923
|
|
Customer#000007603 April 44936847.00 19970410 19970422
|
|
Customer#000007603 December 140826821.00 19971203 19971229
|
|
Customer#000007603 February 6756338.00 19970224 19970224
|
|
Customer#000007603 January 13228025.00 19970102 19970102
|
|
Customer#000007603 July 26643005.00 19970705 19970721
|
|
Customer#000007603 June 24788678.00 19970619 19970624
|
|
Customer#000007603 March 14743022.00 19970330 19970330
|
|
Customer#000007603 May 7965026.00 19970529 19970529
|
|
Customer#000007603 Octorber 18343528.00 19971024 19971024
|
|
Customer#000007603 September 4957153.00 19970905 19970923
|
|
Customer#000010774 Augest 24107364.00 19970805 19970816
|
|
Customer#000010774 December 122948511.00 19971204 19971211
|
|
Customer#000010774 February 30707702.00 19970215 19970222
|
|
Customer#000010774 January 5452488.00 19970113 19970113
|
|
Customer#000010774 July 5722713.00 19970716 19970716
|
|
Customer#000010774 June 55198666.00 19970606 19970614
|
|
Customer#000010774 March 71491559.00 19970311 19970328
|
|
Customer#000010774 November 69058986.00 19971109 19971126
|
|
Customer#000010774 Octorber 41452044.00 19971020 19971026
|
|
Customer#000010774 September 25036440.00 19970930 19970930
|
|
Customer#000011731 April 21010770.00 19970405 19970405
|
|
Customer#000011731 Augest 45281533.00 19970809 19970830
|
|
Customer#000011731 December 139417016.00 19971205 19971220
|
|
Customer#000011731 February 22985450.00 19970207 19970211
|
|
Customer#000011731 January 50528512.00 19970117 19970131
|
|
Customer#000011731 July 10747859.00 19970709 19970709
|
|
Customer#000011731 June 6292314.00 19970616 19970616
|
|
Customer#000011731 March 20465224.00 19970305 19970305
|
|
Customer#000011731 September 8316196.00 19970902 19970908
|
|
Customer#000013396 April 18029353.00 19970412 19970425
|
|
Customer#000013396 December 116662602.00 19971205 19971228
|
|
Customer#000013396 February 25785304.00 19970225 19970225
|
|
Customer#000013396 January 17883861.00 19970121 19970127
|
|
Customer#000013396 July 20154854.00 19970704 19970704
|
|
Customer#000013396 May 30013896.00 19970501 19970521
|
|
Customer#000013396 Octorber 62557053.00 19971009 19971031
|
|
Customer#000013396 September 24508449.00 19970906 19970906
|
|
Customer#000015715 April 16488864.00 19970414 19970414
|
|
Customer#000015715 December 130063207.00 19971201 19971225
|
|
Customer#000015715 July 3843624.00 19970720 19970720
|
|
Customer#000015715 June 32091988.00 19970618 19970624
|
|
Customer#000015715 March 19359787.00 19970308 19970308
|
|
Customer#000015715 May 52332370.00 19970512 19970526
|
|
Customer#000015715 November 45275020.00 19971115 19971130
|
|
Customer#000015715 September 44116849.00 19970906 19970929
|
|
Customer#000018211 April 35495129.00 19970425 19970425
|
|
Customer#000018211 December 114244135.00 19971210 19971228
|
|
Customer#000018211 February 15447237.00 19970220 19970220
|
|
Customer#000018211 July 23683773.00 19970727 19970727
|
|
Customer#000018211 June 978426.00 19970606 19970606
|
|
Customer#000018211 March 1171624.00 19970319 19970319
|
|
Customer#000018211 May 32311651.00 19970506 19970518
|
|
Customer#000018211 September 264848.00 19970927 19970927
|
|
Customer#000019123 April 9166502.00 19970420 19970420
|
|
Customer#000019123 December 119723270.00 19971201 19971230
|
|
Customer#000019123 February 32932048.00 19970212 19970214
|
|
Customer#000019123 January 34771024.00 19970121 19970126
|
|
Customer#000019123 July 35836420.00 19970705 19970720
|
|
Customer#000019123 March 55962971.00 19970311 19970314
|
|
Customer#000019123 May 19076319.00 19970518 19970524
|
|
Customer#000019123 November 30034974.00 19971112 19971112
|
|
Customer#000019123 Octorber 33170059.00 19971013 19971013
|
|
Customer#000019123 September 18950129.00 19970910 19970919
|
|
Customer#000028558 April 20820127.00 19970405 19970411
|
|
Customer#000028558 Augest 4305224.00 19970815 19970815
|
|
Customer#000028558 December 113138659.00 19971208 19971228
|
|
Customer#000028558 March 33782060.00 19970330 19970330
|
|
Customer#000028558 November 3686042.00 19971126 19971126
|
|
Customer#000028558 Octorber 34536253.00 19971011 19971011
|
|
Customer#000028558 September 26372157.00 19970907 19970909
|
|
select count(*) from lineorder where lo_orderdate between 19970101 and 19970105 and lo_custkey not in ( select lo_custkey from (select lo_custkey from lineorder where lo_orderdate between 19971201 and 19971201 ) a );
|
|
count(*)
|
|
11926
|