Guest User

Untitled

a guest
Sep 18th, 2019
106
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO Brands (BrandName, YearEstablished, CEO)
  2. VALUES ("Nextbit Robin", 2015, "Min Liang Tan");
  3.  
  4. DELETE FROM Purchases
  5. WHERE Purchases.ProductId = (SELECT Products.ProductId
  6. FROM Products NATURAL JOIN Brands
  7. WHERE Brands.BrandName = (SELECT BrandName
  8. FROM Brands
  9. WHERE CEO = 'George Zhao')
  10. )
  11. OR Purchases.ProductId = (SELECT Products.ProductId
  12. FROM Products
  13. WHERE Products.YearReleased < (SELECT AVG(Products.YearReleased) From Products)
  14. )
  15. ;
RAW Paste Data