CS403 Assignments # 3 Solution Spring 2012

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

Documentary Table

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

Solution can be found on next page…

Solution(a):

ALL SQL Statements…

Create table Documentary (

Doc_No int,

Title Varchar(50),

Ranking varchar(2),

YearReleased smalldatetime );

Select * from Documentary;

Insert into documentary (Doc_No,Title,Ranking,YearReleased) values (1,’Hoop Dreams’,’A’,’1994′);

Insert into documentary (Doc_No,Title,Ranking,YearReleased) values (2,’The Thin Blue Line’,’B’,’2000′);

Insert into documentary (Doc_No,Title,Ranking,YearReleased) values (3,’Surprise Me ‘,’A’,’2004′);

Insert into documentary (Doc_No,Title,Ranking,YearReleased) values (4,’Trouble the Water ‘,’C’,’2008′);

Insert into documentary (Doc_No,Title,Ranking,YearReleased) values (5,’Dark Days’,’B’,’2000′);

Insert into documentary (Doc_No,Title,Ranking,YearReleased) values (6,’Paris In Burning’,’B’,’1991′);

Insert into documentary (Doc_No,Title,Ranking,YearReleased) values (7,’Man on Wire’,’A’,’2008′);

Select * from Documentary;

Select Title, Year Released from documentary where Ranking = ‘B’;

Note: This Query will written to find the resultant table.

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

Documentary Table

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’;

Solution(b): Resultant table would be:

/****************** download soltuion file from here **********************\

CS403 Mega Collection Solved files for midterm papers by Muhammad Ishfaq