function selectAttendees(courseId) {
  const queryText = `
    SELECT users.userid, isstudent, islecturer, ismodulecoordinator, firstname, lastname
    FROM attends
    INNER JOIN users ON users.userid = attends.userid
    WHERE courseid = $1
    AND isactive AND isemailverified
    AND (isstudent OR islecturer OR ismodulecoordinator)
    ORDER BY users.firstname, users.lastname, users.userid`;
  const params = [courseId];
  return databaseQuery(queryText, params);
}
/**
 * returns userid and the roles of all active users attending course
 *
 * @param {number} courseId id of attended course
 */
returns userid and the roles of all active users attending course
@param {number} courseId id of attended course
returns userid and the roles of all active users attending course @param { number } courseId id of attended course
function selectAttendees(courseId) {
  const queryText = `
    SELECT users.userid, isstudent, islecturer, ismodulecoordinator, firstname, lastname
    FROM attends
    INNER JOIN users ON users.userid = attends.userid
    WHERE courseid = $1
    AND isactive AND isemailverified
    AND (isstudent OR islecturer OR ismodulecoordinator)
    ORDER BY users.firstname, users.lastname, users.userid`;
  const params = [courseId];
  return databaseQuery(queryText, params);
}
function selectAttendees ( courseId ) { const queryText = ` ` ; const params = [ courseId ] ; return databaseQuery ( queryText , params ) ; }
returns userid and the roles of all active users attending course
 @param {number} courseId id of attended course
returns userid and the roles of all active users attending course @param { number } courseId id of attended course