# Help with a little query

**URL:** https://discourse.julialang.org/t/help-with-a-little-query/4723
**Category:** Data
**Created:** [July 7, 2017, 6:27pm UTC](https://discourse.julialang.org/t/help-with-a-little-query/4723 "2017-07-07T18:27:44Z")
**Posts on this page:** 1
**Showing post:** 8

<div class="post-metadata">

### Author: ![aaowens](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/aaowens/32/12101_2.png) [@aaowens](https://discourse.julialang.org/u/aaowens)
#### Post date: [July 9, 2017, 7:00pm UTC](https://discourse.julialang.org/t/help-with-a-little-query/4723/8 "2017-07-09T19:00:16Z")

</div>

Ok, I think I get it. The following query works.

```julia
function myfun(A, B)
  mean(A) + mean(x -> x^2, B)
end
sdt = @from i in load("sisec_mus_2017_full.csv") begin
    @group @NT(score = i.score, track_id = i.track_id) by @NT(metric = i.metric, method = i.method) into g
    @select {g.key.metric, m = myfun(map(j -> j.score, g), map(j -> j.track_id, g) ) }
    @collect DataTable
end

```

This is pretty ugly though, but I see how the … syntax would clean it up a lot.

---

_[View the full topic](https://discourse.julialang.org/t/help-with-a-little-query/4723)._