Untitled

From Tinct Moth, 9 Months ago, written in Plain Text, viewed 94 times.
URL http://codebin.org/view/065b2940 Embed
Download Paste or View Raw
  1. SELECT
  2.   billing_country,
  3.   COUNT(billing_postal_code IS NULL)
  4. FROM
  5.   invoice
  6. WHERE
  7.   billing_address NOT LIKE '%Street%'
  8.   AND billing_address NOT LIKE '%Way%'
  9.   AND billing_address NOT LIKE '%Road%'
  10.   AND billing_address NOT LIKE '%Drive%'
  11. GROUP BY
  12.   billing_country
  13. HAVING
  14.   COUNT(billing_postal_code IS NULL)> 10;
  15.  
  16.  
  17. ошибка: слишком много строк в полученном результате

Reply to "Untitled"

Here you can reply to the paste above