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 Embed
Download Paste or View Raw
  1. SELECT billing_country,
  2.        COUNT(billing_postal_code)
  3. FROM invoice
  4. WHERE billing_postal_code IS NULL
  5.   AND billing_address LIKE '%Street%'
  6.    OR billing_address LIKE '%Way%'
  7.    OR billing_address LIKE '%Road%'
  8.    OR billing_address LIKE '%Drive%'
  9. GROUP BY billing_country
  10. HAVING COUNT(*)-COUNT(billing_postal_code) > 10;

Replies to Re: task 2 rss

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