Execution finished with errors. Result: near "(": syntax error At line 1:

DB Browser for SQLite 3.12.2 Linux AppImage

DB Browser for SQLite Version 3.12.1

Execution finished without errors. Result: 2 rows returned in 11ms At line 1:

with seqta_sub as (
    select distinct
    House,
    StudentCode as 'Student ID',
    Surname || ', ' || preferred as 'Student',
    YearLevel as 'Year_Level',
    substr(Roll,14,2) as 'Roll Group',
    SubjectCode as 'Class Code',
    Subject,
    Teacher,
    Affective1 as 'Progress Grade',
    '' as 'Att Rate Ave'
from tbl_seqta
    where StudentCode like '106253435A' and (CalcGrade like 'D%' or CalcGrade like 'E%' or CalcGrade like 'N%' or CalcGrade like 'X')
    order by House, Roll, YearLevel, StudentCode, Surname, Preferred    
),
level_sub as (
    select
        *,
        count(*) over (partition by 'Student ID') as den_count
    from
        seqta_sub
)
select 
    *,
    case
        when den_count >= 1 and Year_Level = '12' then 'level 3'
        when den_count >= 1 and den_count <= 2 then 'level 1'
        when den_count >= 3 and den_count <= 4 then 'level 2'
        when den_count >= 5 then 'level 3'
    end as level
from level_sub

sqlitebrowser / sqlitebrowser

Execution finished with errors. Result: near "(": syntax error At line 1: #3586