SQL command/I'm stuck

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. Received on Sat Jun 29 2002 - 22:32:35 CDT