a guest Mar 26th, 2019 86 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- 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;
- SELECT customers. customerName, COUNT(*) LEFT JOIN orders ON customers.customerNumber=orders.customerNumber WHERE customers.country IN ('Poland', 'Germany') and orders.orderNumber IS NULL
- 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;
- SELECT country.name, COUNT(*) FROM country LEFT JOIN City ON country.code=city.countryCode WHERE city.name IS NULL
RAW Paste Data