LangWatch
SQL
Tags:
data-oriented
,
declarative
,
extension
Related tools:
Example 1
SELECT
l
.
name
as
name, coalesce(
l
.
simpleName
,
l
.
name
)
as
simpleName,
SUM
(
h
.
hits
)
as
hitCount
FROM
hits h
JOIN
languages l
on
l
.
id
=
h
.
languageId
WHERE
h
.
date
>
datetime
(
'
now
'
,
'
-6 days
'
)
GROUP BY
h
.
languageId
ORDER BY
hitCount
DESC
LIMIT
25
SQL Summary
Language
SQL
Home Page