a guest Mar 26th, 2019 88 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT * FROM customers  INNER JOIN orders ON customers.customerNumber=orders.customerNumber WHERE'USA' and orders.status='Cancelled' and Month(orders.orderDate) BEETWEN 1 AND 3;
  2. SELECT customers. customerName, COUNT(*) LEFT JOIN orders ON customers.customerNumber=orders.customerNumber WHERE IN ('Poland', 'Germany') and orders.orderNumber IS NULL
  4. SELECT * FROM Country INNER JOIN City ON Country.Code=City.countryCode WHERE country.continent IN ('Europe', 'Asia') and city.population>1000000 and country.lifeExpectancy>80;
  5. SELECT, COUNT(*) FROM country LEFT JOIN City ON country.code=city.countryCode WHERE IS NULL
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