Blackboard Learn Logo
Home » Blackboard » Blackboard Learn » SQL Queries » SQL: Total Number of Announcements Created Per Course

SQL: Total Number of Announcements Created Per Course


Identifies the total number of announcements created per course.

Data Source: Blackboard DDA on SaaS


SELECT cm.course_name, count(a.pk1) as total_number_of_announcements
FROM PUBLIC.announcements a
INNER JOIN PUBLIC.course_main cm
ON cm.pk1 = a.crsmain_pk1
WHERE cm.course_id LIKE '%.202020' -- Filters by Course ID
AND cm.row_status = '0' -- Only Active Courses
AND a.start_date BETWEEN '2020-01-01 00:00:00' AND '2020-05-11 23:59:59' -- Filters never accessed and accessed more than 7 days
GROUP BY cm.course_name
ORDER BY total_number_of_announcements desc

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 1

No votes so far! Be the first to rate this post.

Eric Silva

Eric is a Systems Analyst and Blackboard Administrator at The University of Texas at San Antonio, and a graduate from Boise State University. Learn more about me.


Add comment

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.