How to find the records that do not have a specific value on a different column?

For example:

My Table:

How can I find all the Accountid that do not have any record with Type = A.

So the result should be:

Thank you!

>Solution :

WITH
  check_type AS
(
  SELECT
    *,
    MAX(
      CASE WHEN type = 'A' THEN 1 ELSE 0 END
    )
    OVER (
      PARTITION BY account_id
    )
      AS account_has_type_a
  FROM
    your_table
)
SELECT
  *
FROM
  check_type
WHERE
  account_has_type_a = 0