SQL

SQL

Made by DeepSource

Inconsistent function names SQL-L030

Style
Minor

Inconsistent capitalisation of function names.

Bad practice

In this example, the two SUM functions don't have the same capitalisation.

SELECT
    sum(a) AS aa,
    SUM(b) AS bb
FROM foo

Recommended

Make the case consistent.

SELECT
    sum(a) AS aa,
    sum(b) AS bb
FROM foo