odbtools/odbctest/mql/uino/101.综合测试.mql

-- SELECT 
--     contract.attr15 AS "平均合同金额" 
--     FROM /mingdao1/contract contract 
--     LIMIT 0, 20000
-- /**
-- output()
-- **/
-- ;

-- SELECT 
--     avg(contract.attr15) AS "平均合同金额" 
--     FROM /mingdao1/contract contract 
--     LIMIT 0, 20000
-- /**
-- output()
-- **/
-- ;


-- create ('trans:01056319') - [:trans_account_id_account_account_id] -> ('account:00004428')
-- /**
-- output()
-- **/
-- ;

-- match (a:'trans:01056319') - [:trans_account_id_account_account_id] -> (b:'account:00004428') return a.id,b.id
-- /**
-- output()
-- **/
-- ;


-- select id, staff_perf.time('2025-04-01 00:00:00','2025-04-11 00:00:00') from /mingdao1/staff 
-- WHERE staff_perf.time('2025-04-01 00:00:00','2025-04-11 00:00:00').find(name = 'CN003570S').unit('avg', '1d').assert($1 > 3)


-- MATCH (yearmonth:/birddata/yearmonth WHERE date like 'xxx2012*')-[:yearmonth_customerid_customers_customerid*1..1]->(customer:/birddata/customers WHERE segment = 'xxxLAM') 
-- RETURN customer.customerid AS "customer_id", yearmonth.consumption AS "consumption" INTO /t0;
-- /**
-- output()
-- **/
-- ;

-- select id from /birddata/yearmonth WHERE date like '2012*' limit -1
-- -- 158808 rows, usetime=55.781458454s
-- /**
-- output()
-- **/
-- ;

-- select id from /birddata/customers WHERE segment = 'LAM' limit -1
-- -- 3658 rows, usetime=1m44.720676302s
-- /**
-- output()
-- **/
-- ;

-- select id,date,customerid, consumption,yearmonth_customerid_customers_customerid from /birddata/yearmonth where customerid=7653 and date like '2012*'
-- /**
-- output()
-- **/
-- ;


-- select * from /birddata/customers WHERE segment = 'LAM' and customerid=7653
-- /**
-- output()
-- **/
-- ;


-- MATCH (yearmonth:/birddata/yearmonth WHERE date like '2012*' and customerid=7653)-[:yearmonth_customerid_customers_customerid*1..1]->(customer:/birddata/customers WHERE segment = 'LAM' and customerid=7653)

-- /**
-- output()
-- **/
-- ;


-- MATCH (yearmonth:/birddata/yearmonth WHERE date like '2012*')-[:yearmonth_customerid_customers_customerid*1..1]->(customer:/birddata/customers WHERE segment = 'LAM') 
-- RETURN customer.customerid AS "customer_id", yearmonth.consumption AS "consumption" INTO /t0;

-- SELECT t0.customer_id AS "Customer ID", sum(t0.consumption) AS "Total Consumption" FROM /t0 t0 
-- GROUP BY t0."customer_id" ORDER BY "Total Consumption" ASC LIMIT 0, 1
-- /**
-- output()
-- **/
-- ;

-- select id.id from /birddata/yearmonth id WHERE date like '2012*' and customerid=7653
-- /**
-- timeout(10m)
-- output()
-- **/
-- ;

--  SELECT consumption.consumption AS "consumption_amount" INTO /t0 FROM /birddata/yearmonth consumption WHERE customerid = 6 AND date between '201308' AND '201311' LIMIT 0, 20000;

-- select * from /t0


-- SELECT consumption.consumption AS "consumption_amount" , customerid, date  
-- FROM /birddata/yearmonth consumption where customerid = 6 and 
-- date >= '201305' AND date <= '20131100'

-- MATCH (yearmonth:/birddata/yearmonth WHERE date like '2012*')
-- -[:yearmonth_customerid_customers_customerid*1..1]->
-- (customer:/birddata/customers WHERE segment = 'LAM' and customerid=7653) 

-- select id, staff_perfx.time('2025-04-01 00:00:00','2025-04-11 00:00:00') from /mingdao1/staff

-- select * from /birddata/yearmonth where  yearmonth_customerid_customers_customerid is not null 

-- select id, staff_perf.time('2025-04-01 00:00:00','2025-04-13 00:00:00') from /mingdao1/staff with timeout=2m limit 1000

select * from /mingdao1/staff WHERE  is_admin_of_project is not null

/**
timeout(2m)
output()
**/
;