How to do logic OR AND NOT across rows in SQL

Scenario You have a normalized table that has values in rows.   Let’s take an example that has a history table with an approved flag:  Date  Approved  DollarValue  Customer1/1/2008  Y    13.5    A2/1/2008  N    12      A3/1/2008  Y    14      A 1/1/2008  Y    11.5    B2/1/2008  Y    9        B3/1/2008  Y    17      B 1/1/2008  Y    13.5    C2/1/2008  Y    29        C3/1/2008  Y    18      C  You…

0