Shell Programming and Scripting

 ad_d | code  | start    | end      | amountscore | id    | amount_class |
+--------+--------+----------+----------+----------+--------------+--------------+
|      1 | ww      |   935002 |   935100 |      245 | Ath | boeing         |
|      1 | e      |  4406486 |  4406628 |      575 | Lth | boeing         |
|      1 | r      | 30313484 | 30313585 |      348 | SSU | boeing         |
|      18 | f      | 44787276 | 44787468 |     1338 | SSU | boeing         |
|      1 | g     | 44787462 | 44787856 |     2775 | Ath | target         |
|      1 | m      | 44787855 | 44787944 |      747 | Ath | boeing         |
|      1 | n      | 53636773 | 53636856 |      549 | SSU | target         |
|      1 | m      | 53888147 | 53888282 |      695 | SSU | genev         |
|      1 | q      | 53888312 | 53888394 |      399 | Ath | boeing         |
|      1 | c      | 53888396 | 53888428 |      251 | Ath | geneva         |
|      1 | f      | 53888461 | 53888589 |      583 | gth | geneva

select * 
from (
      select *
      from DB1.orders
      except
      select *
      from DB2.orders
     ) as amountclass
Where amount_class ='Boeing';