• branch@lemmy.world
    link
    fedilink
    arrow-up
    2
    ·
    1 day ago
    CREATE VIEW NiceList AS
     SELECT * FROM Children
      WHERE behavior > 2000
       AND parent.income > 40000; 
    CREATE VIEW NaughtyList AS
     SELECT * FROM Children
      WHERE behavior <= 2000;