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
15 lines
376 B
SQL
15 lines
376 B
SQL
-- name: ListAuthors :many
|
|
SELECT id, name as name, bio
|
|
FROM authors;
|
|
|
|
-- name: ListAuthorsIdenticalAlias :many
|
|
SELECT id, name as name, bio
|
|
FROM authors;
|
|
|
|
-- name: ListMetrics :many
|
|
SELECT date_trunc('day', time) AS bucket, city_name, AVG(temp_c)
|
|
FROM weather_metrics
|
|
WHERE time > NOW() - (6 * INTERVAL '1 month')
|
|
GROUP BY bucket, city_name
|
|
ORDER BY bucket DESC;
|