odbtools/odbctest/mql/uino/201.return table uniqu.mql

MATCH (player_attr:/birddata/player_attributes)-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:/birddata/player WHERE player_name = 'Ahmed Samir Farag') 
RETURN distinct player_attr.long_shots AS "long_shots"
/**
timeout(5m)
output()
metainfo()
**/;


MATCH (player_attr:/birddata/player_attributes)-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:/birddata/player WHERE player_name = 'Ahmed Samir Farag') 
RETURN player_attr.long_shots AS "long_shots", player_attr.id
/**
timeout(5m)
output()
metainfo()
**/;

MATCH (player_attr:/birddata/player_attributes)-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:/birddata/player WHERE player_name = 'Ahmed Samir Farag') 
RETURN player_attr.long_shots AS "long_shots"
/**
timeout(5m)
output()
metainfo()
**/;

MATCH (player_attr:/birddata/player_attributes)-[:player_attributes_player_api_id_player_player_api_id*1..1]->(player:/birddata/player WHERE player_name = 'Ahmed Samir Farag') 
RETURN player_attr.long_shots AS "long_shots" INTO /qqq0
/**
timeout(5m)
output()
metainfo()
**/;

select * from /qqq0
/**
output()
**/;

SELECT avg(t0.long_shots) AS "average_long_shots" FROM /qqq0 t0 LIMIT 0, 20000
/**
output()
**/;