1. SELECT *

    2. FROM J;

    Or Simply:

    TABLE J;

  2. SELECT J *

    3. FROM J

    WHERE J.CITY = ‘London’;

  3. SELECT DISTINCT SPJ.S#

    4. FROM SPJ

    WHERE SPJ.J# = ‘J1’;

  4. SELECT SPJ.*

    5. FROM SPJ

    WHERE SPJ.QTY >= 300

    AND SPJ.QTY <= 750;

  5. SELECT DISTINCT P.COLOR, P.CITY

    6. FROM P;

  6. SELECT S.S#, P.P#, J.J#

    7. FROM S, P, J

    WHERE S.CITY = P.CITY

    AND P.CITY = J.CITY;

  7. SELECT S.S#, P.P#, J.J#

    8. FROM S, P, J

    WHERE NOT (S.CITY = P.CITY AND

    P.CITY = J.CITY);

  8. SELECT S.S#, P.P#, J.J#

    9. FROM S, P, J

    WHERE S.CITY <> P.CITY

    AND P.CITY <> J.CITY

    AND J.CITY <> P.CITY;

  9. SELECT DISTINCT SPJ.P#

    10. FROM SPJ

    WHERE (SELECT S.CITY

    FROM S

    WHERE S.S# = SPJ.S#) = ‘London’;

  10. SELECT DISTINCT SPJ.P#

    11. FROM SPJ

    WHERE (SELECT S.CITY

    FROM S

    WHERE S.S# = SPJ.S# ) = ‘London’

    AND (SELECT J.CITY

    FROM J

    WHERE J.J# = SPJ.J#) = ‘London’;

  11. SELECT DISTINCT S.CITY AS SCITY, J.CITY AS JCITY

    12. FROM S, J

    WHERE EXISTS

    (SELECT *

    FROM SPJ

    WHERE SPJ.S# = S.S#

    AND SPJ.J# = J.J#);

  12. SELECT DISTINCT SPJ.P#

    13. FROM SPJ

    WHERE (SELECT S.CITY

    FROM S

    WHERE S.S# = SPJ.S#) =

    (SELECT J.CITY

    FROM J

    WHERE J.J# = SPJ.J#);

  13. SELECT DISTINCT SPJ.J#

    14. FROM SPJ

    WHERE (SELECT S.CITY

    FROM S

    WHERE S.S# = SPJ.S#) <>

    (SELECT J.CITY

    FROM J

    WHERE J.J# = SPJ.J#);

  14. SELECT DISTINCT SPJX.P# AS PA, SPJY.P# AS PB

    15. FROM SPJ AS SPJX, SPJ AS SPJY

    WHERE SPJX.S# = SPJY.S#

    AND SPJX.P# < SPJY.P#;

  15. SELECT COUNT (DISTINCT SPJ.J#) AS N

FROM SPJ

WHERE SPJ.S# = ‘S1’;