Re: task 2

From Commodious Pheasant, 9 Months ago, written in Plain Text, viewed 304 times. This paste is a reply to task 2 from Ilya - view diff

URL http://codebin.org/view/10acdd44 Embed

Download Paste or View Raw

SELECT billing_country,
       COUNT(billing_postal_code)
FROM invoice
WHERE billing_postal_code IS NULL
  AND billing_address LIKE '%Street%'
   OR billing_address LIKE '%Way%'
   OR billing_address LIKE '%Road%'
   OR billing_address LIKE '%Drive%'
GROUP BY billing_country
HAVING COUNT(*)-COUNT(billing_postal_code) > 10;

Replies to Re: task 2

Title	Name	Language	When
Re: Re: task 2	Unique Marten	text	9 Months ago.

Reply to "Re: task 2"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?