The first query gives the number of available courses (non archived, non deleted).

The second queries gives the list of available courses

Query

SELECT
    count(*) as nb_available_courses
FROM qwnogpy_ww21770_datasharing.core.courses
WHERE not coalesce(is_archived, false) and deleted_at is null

;

SELECT
    *
FROM qwnogpy_ww21770_datasharing.core.courses
WHERE not coalesce(is_archived, false) and deleted_at is null