ludiusvox
/
TaskProject


  
1

	
2

	
3

	
4

	
5

	
6

	
7

	
8

	
9

	
10

	
11

	
12

	
13

	
14

	
15

	
16

	
17

	
18

	
19

	
20

	
            --1 Print all the projects in which a specified student is involved
SELECT pname
FROM Project
WHERE pid IN (SELECT pid FROM Assigned WHERE sid = (SELECT sid FROM Student WHERE sname = 'Landen'));


--Print all the people working on a specified project.
SELECT fname
FROM Faculty
WHERE fid IN (SELECT pi FROM Project WHERE pname = 'Website Redesign')
   OR fid IN (SELECT copi FROM Project WHERE pname = 'Website Redesign');
   
--Print all the projects supervised by a specified faculty within a specified time range. 
SELECT pname
FROM Project
WHERE pi = (SELECT fid FROM Faculty WHERE fname = 'Jane')
  AND sdate >= '2024-02-15'
  AND edate <= '2024-05-15';