cs403 Assignment no 3 Spring 2012 Idea Solution

Total Marks: 10

Due Date: 12-06-2012

1(a). Consider the table below:            Marks: 5

Documentary Table

Doc_No	Title	Ranking	YearReleased
1	Hoop Dreams	A	1994
2	The Thin Blue Line	B	2000
3	Surprise Me	A	2004
4	Trouble the Water	C	2008
5	Dark Days	B	2000
6	ParisIn Burning	B	1991

You are required to write an SQL statement using SELECT operator, which will give the following resultant table.

Title	YearReleased
The Thin Blue Line	2000
Dark Days	2000
ParisIn Burning	1991

1(b). Consider the table below:    Marks: 5
Documentary Table

Doc_No	Title	Ranking	YearReleased
1	Hoop Dreams	A	1994
2	The Thin Blue Line	B	2000
3	Surprise Me	A	2004
4	Trouble the Water	C	2008
5	Dark Days	B	2000
6	Parisof Burning	B	1991
7	Man on Wire	A	2008

You are required to show the resultant relation that will be produced by the following SQL SELECT statement.

SELECT Doc_No, Title, YearReleased     
FROM
Documentary
WHERE  YearReleased <>‘2000’;