Consider two tables student(ssn, name, major) and transcript(ssn,grade) where ssn is primary key in student and foreign key in transcript. How do we find the students who received A in at least two transcripts with major CS. I have tried using having, group by to get the solution, but we shouldn't use group by and having. For three I have just replaced with the number at the end. Thank you for the answer in advance.

SELECT
  s.ssn,
  s.name,
  s.major
FROM student s
INNER JOIN (
  SELECT 
    ssn,
    COUNT(grade) as number_of_grades
  FROM transcript
  WHERE grade = 'A'
  GROUP BY ssn
) grade_count
ON grade_count.ssn = s.ssn

WHERE grade_count.number_of_grades >= 2