SHARE
TWEET

Untitled

a guest Sep 18th, 2019 98 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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top