8000 update prql examples to use prql v0.9.5 · RandomFractals/duckdb-sql-tools@22f2ade · GitHub
[go: up one dir, main page]
Skip to content

Commit 22f2ade

Browse files
RandomFractalsRandomFractals
committed
update prql examples to use prql v0.9.5
1 parent 96583c3 commit 22f2ade

File tree

3 files changed

+10
-10
lines changed

3 files changed

+10
-10
lines changed

‎data/chinook/duckdb/employees-by-age.prql

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
from employees
2-
derive [
3-
age = (@2023-02-12 - birth_date) / 365
4-
]
5-
select [employee_id, first_name, last_name, birth_date, age]
2+
derive {
3+
age = (@2023-10-14 - birth_date) / 365
4+
}
5+
select {employee_id, first_name, last_name, birth_date, age}

‎data/chinook/duckdb/employees-by-birth-date.prql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,3 @@
11
from employees
2-
select [employee_id, first_name, last_name, birth_date]
2+
select {employee_id, first_name, last_name, birth_date}
33
sort birth_date

‎data/gbif/top-10-duck-species-observations.prql

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -2,10 +2,10 @@ from s'select * from read_parquet(
22
"s3://gbif-open-data-us-east-1/occurrence/2023-03-01/occurrence.parquet/000000"
33
)'
44
filter genus == 'Anas'
5-
group [genus, species] (
6-
aggregate [
7-
total = count
8-
]
5+
group {genus, species} (
6+
aggregate {
7+
total = count genus
8+
}
99
)
10-
sort [-total]
10+
sort {-total}
1111
take 10

0 commit comments

Comments
 (0)
0