daily pastebin goal
24%
SHARE
TWEET

Jbhu

a guest Mar 26th, 2019 86 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 customers.country='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 customers.country IN ('Poland', 'Germany') and orders.orderNumber IS NULL
  3.  
  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 country.name, COUNT(*) FROM country LEFT JOIN City ON country.code=city.countryCode WHERE city.name 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
 
Top