Gitiles
Code Review
Sign In
asterix-gerrit.ics.uci.edu
/
asterixdb
/
1445153fda37f0d244bb1648c27ac5df4c47a852
/
.
/
asterix-app
/
src
/
test
/
resources
/
old-optimizerts
/
queries
/
spj01.aql
blob: 28fd2c8d48e4e14b29f1dab4d10765e2df10934d [
file
] [
log
] [
blame
]
declare
function
samecust
(
$cust
,
$ord
)
{
$cust
.
cid
=
$ord
.
cid
}
for
$c
in
dataset
(
'Customers'
)
for
$o
in
dataset
(
'Orders'
)
where
samecust
(
$c
,
$o
)
and
$c
.
age
<
21
and
$o
.
total
>
1000.00
return
{
"custname"
:
$c
.
name
,
"orddate"
:
$o
.
date
}