3 ms·
PRQL translation: from cars filter brand == "BMW" group year ( aggregate [ average_price = average price ] ) sort year
by thiht 2y ago
PRQL translation:
from cars
filter brand == "BMW"
group year (
aggregate [
average_price = average price
]
)
sort year
select average_price
A bit longer, but I love that it reads from top to bottom. When you have a complex SQL query, I’ve sometimes found it easier to write it as PRQL and then convert it to SQL
https://prql-lang.org/ https://prql-lang.org/