SQLTask

SELECT (
  SELECT "Email"
  FROM Activities_Participants
  WHERE Activities."ActivityID" == ActivityID
) AS "Email",
(
  SELECT "ActivityDate"
  FROM Activities_Participants
  WHERE Activities."ActivityID" == ActivityID
) AS "Date",
"Name",
"Type",
"SubType" +
  IF(
    "Type" IN('TypeA', 'TypeB', 'TypeC') AND
    "SubType" NOT IN('TypeC'),
      ' Needed_Activity',
      '') +
  IF(
    SELECT "ActivityDate"
    FROM Activities_Participants < getdate(),
      ' Net_New_Activity',
      '') AS "SubType"
WHERE YEAR(getdate()) == (
  SELECT YEAR("ActivityDate")
  FROM Activities_Participants
  WHERE Activities."ActivityID" == "ActivityID"
)