SQL with values

SQL with values

with studenten (name, note) as (values("Felix", 1),
                                      ("Woojin", 2),
                                      ("Clemens", 3))

select avg(note), count(*) from studenten
where note > 2; select 5
Calendar July 21, 2022 (Updated October 22, 2023)