forked from lloydtabb/imdb
-
Notifications
You must be signed in to change notification settings - Fork 0
/
stars_and_jobs.malloynb
32 lines (32 loc) · 1.16 KB
/
stars_and_jobs.malloynb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
[
{
"kind": 1,
"language": "markdown",
"value": "# Movie stars, titles time and jobs\nMovie people work lots of jobs. Take a look at the top stars, what they work on, how long they have been working and what they do.",
"metadata": {}
},
{
"kind": 2,
"language": "malloy",
"value": "import \"imdb.malloy\"",
"metadata": {}
},
{
"kind": 2,
"language": "malloy",
"value": "query: movies-> {\n where: ratings.numVotes > 50000 \n nest: star_dashboard is by_name + { \n nest: \n by_title + { limit: 5}\n by_year_line_chart is by_year\n by_job_category\n limit: 10 \n }\n} ",
"metadata": {}
},
{
"kind": 1,
"language": "markdown",
"value": "## Comedy movie stars titles time and jobs\nFilter the data to only look in the genre 'comedy' and examine the top folks.",
"metadata": {}
},
{
"kind": 2,
"language": "malloy",
"value": "query: movies-> {\n where: genres.value = 'Comedy'\n nest: star_dashboard is by_name + { \n nest: \n by_title + { limit: 5}\n by_year_line_chart is by_year\n by_job_category\n limit: 10 \n }\n} ",
"metadata": {}
}
]