SQLD · 모의고사 11회 · 49번

SELECT COUNT(*)
FROM (
  SELECT DISTINCT A, B
  FROM Data_A
  WHERE C IN (
    SELECT D
    FROM Data_B
    WHERE LOWER(E) = 'p'
  )
) X;