0f4df23290
Some checks failed
kotlin / test (push) Has been skipped
python / test (push) Has been skipped
typescript / test (push) Has been skipped
go / build darwin/amd64 (push) Has been cancelled
go / build linux/amd64 (push) Has been cancelled
go / build windows/amd64 (push) Has been cancelled
go / build darwin/arm64 (push) Has been cancelled
go / build linux/arm64 (push) Has been cancelled
go / build windows/arm64 (push) Has been cancelled
go / test (push) Has been cancelled
go / vuln_check (push) Has been cancelled
17 lines
413 B
SQL
17 lines
413 B
SQL
-- name: ListAuthors :many
|
|
SELECT id, name as full_name, bio
|
|
FROM authors
|
|
GROUP BY full_name;
|
|
|
|
-- name: ListAuthorsIdenticalAlias :many
|
|
SELECT id, name as name, bio
|
|
FROM authors
|
|
GROUP BY name;
|
|
|
|
-- name: ListMetrics :many
|
|
SELECT time_bucket('15 days', time) AS bucket, city_name, AVG(temp_c)
|
|
FROM weather_metrics
|
|
WHERE DATE_SUB(NOW(), INTERVAL 6 MONTH)
|
|
GROUP BY bucket, city_name
|
|
ORDER BY bucket DESC;
|