Re: SQL command/I'm stuck

ImPrecise wrote:

> 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!

You are assuming one table. You are braver than I.

But this is obviously homework from a class. As a teacher, myself, I would prefer that hints be given and not complete answers.

Daniel Morgan Received on Mon Jul 01 2002 - 10:45:50 CDT