SELECT  brain    
  FROM anywhere      
  WHERE yourbrain < peoplebrain;

SELECT *   FROM work      
   WHERE money > yourcash      
   AND yourbrain IS NOT NULL;

SELECT *   
   FROM life      
   WHERE  yourcash>funkycash
      AND yourbrain=fullhappy;

SELECT friends   
   FROM yourlife mlife, predatorlife olife      
   WHERE mlife.yourmind= olife.yourmind       
   AND mlife.yourlove= mlife.yourlove      
   AND NOT EXISTS {     
       SELECT 1 FROM blacktable WHERE peopleid=myid}

SELECT place, people   
FROM yourlife mlife, predatorlife olife
      WHERE mlife.yourfood= olife.yourfood       
      AND mlife.yourlove= mlife.yourlove
      AND NOT EXISTS {
            SELECT 1 FROM blacktable WHERE peopleid=myid}

SPOOL my_list_bestpeople.lst

COLUMN num FORMAT ‘9999’ HEADING ‘N’
COLUMN nam FORMAT A17 HEADING ‘name’
COLUMN stat FORMAT A50 HEADING ‘status’

SELECT          
           rownum num,
           place,
           people nam,
           family stat
FROM yourlife mlife, predatorlife olife
WHERE mlife.yourfood= olife.yourfood
 AND mlife.yourlove= mlife.yourlove
 AND mlife.yourfamily= mlife.myfamily
 AND NOT EXISTS {
            SELECT 1 FROM blacktable WHERE peopleid=myid}

SPOOL my_list_shoes.lst

COLUMN num FORMAT ‘9999’ HEADING ‘N’
COLUMN nam FORMAT A17 HEADING ‘name’
COLUMN bra FORMAT A50 HEADING ‘brand’

SELECT
          rownum num,
          place,
          all  nam,
          exclusive_name statFROM
          yourlife mlife,
          predatorlife olife
   WHERE mlife.yourshoes= olife.yourshoes
    AND mlife.yourlove= mlife.yourlove
   AND mlife.yourbrand= mlife.mybrand
   AND NOT EXISTS {
        SELECT 1 FROM blacktable WHERE allshoes=myshoes
}

SPOOL OFF;

EXIT;

SPOOL your_list_dreams.lst

COLUMN num FORMAT ‘9999’ HEADING ‘N’
COLUMN nam FORMAT A17 HEADING ‘name’
COLUMN com FORMAT A50 HEADING ‘comments’

SELECT
          rownum num, 
          place, 
         all  nam,
         exclusive_name stat,
        comments com
FROM yourlife mlife, predatorlife olife
   WHERE mlife.yourshoes= olife.yourshoes
    AND mlife.yourlove= mlife.yourlove
   AND mlife.yourbrand= mlife.mybrand
   AND mlife.yourfood= olife.yourfood
   AND mlife.yourfamily= mlife.myfamily
  AND NOT EXISTS {
                   SELECT 1 FROM blacktable 
                  WHERE allshoes=myshoes
                 AND .yourlove= alllove
                AND yourbrand= allbrand
               AND .yourfood= allfood
                                }

SPOOL OFF;

EXIT;