SQL QUERIES With Solution

SQL QUERIES 

28- Get names of projects supplied by S1.

     

SELECT jname
FROM   SPJ, J
WHERE  spj.jnum = j.jnum
AND    snum = 'S1';

29- (Another Method) Get names of projects supplied by S1.

     

-- using subquery

SELECT jname
FROM   J
WHERE  EXISTS (SELECT *
               FROM   SPJ
               WHERE  spj.jnum = j.jnum
               AND    snum = 'S1');

30- Get part numbers for parts supplied to any project in London.

     
.

SELECT DISTINCT pnum
FROM SPJ
where jnum IN (SELECT jnum 
               FROM J
               WHERE city='London');

31- Get project numbers for projects using at least one part available from S1.

     

SELECT DISTINCT jnum
FROM   SPJ
WHERE  pnum IN (SELECT pnum
              FROM   SPJ
              WHERE  snum = 'S1') ;             

32- Get project numbers for projects whose city is first in the alphabetic list of cities with projects.

     

.

SELECT jnum
FROM   J
WHERE  NOT EXISTS (
              SELECT *
              FROM   SPJ
              WHERE  j.jnum = spj.jnum
              AND    snum <> 'S1');

Previous Page                All Queries                       Next page

. .

. . .