Re: SQL command/I'm stuck

In article <c0f10b81.0206291932.46a7e7c2_at_posting.google.com>,  chico8574_at_hotmail.com (Ric) wrote:

> I'm using SQL 8.0.
>
> I have translated the English sentence of "Get supplier numbers and
> status for suppliers in Paris" to the SQL command:
>
> select s#, status from supplier where upper(city) = 'PARIS';
>
> I don't know what to type for "Get color and city for "non Paris"
> parts with weight greater than 10 (hint: <> is the operator for not)"
>
> Any help would be appreciated.

SELECT
  color, city
FROM
  supplier
WHERE
  UPPER(city) != 'PARIS'
AND
  WEIGHT > 10
/

-- 
The underscore character does not belong in my address. You know the drill...
***
Anyone sufficiently smart enough to configure and use USEnet for research should
be smart enough to Read The Freakin' Documentation!