Practical questions l.jpg
Advertisement
This presentation is the property of its rightful owner.
1 / 9

Practical Questions PowerPoint PPT Presentation

Practical Questions Movie (Title, Year, Length, inColor, StudioName, Producer) Give the SQL Statement that produced the outcome for the following query from the above mention Relation. Find all the movies that produced by Disney Studios in 1990.

Download Presentation

Practical Questions

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Practical questions l.jpg

Practical Questions

Movie (Title, Year, Length, inColor, StudioName, Producer)

Give the SQL Statement that produced the outcome for the following query from the above mention Relation.

Find all the movies that produced by Disney Studios in 1990.

Modify the above query (Q1) to produce only the movie title and length

Modify the above query (Q2) to produce a relation with attributes Name and Duration in place of title and length.

Modify the above query(Q3) to produced length in hours

Find all movies made after 1970 that are in black and white

Find the titles of the movies made by MGM Studios that either were made after 1970 or were less than 90 minutes long.

Search for all movies with a possessive (‘s) in their titles

List the Disney movies of 1990 from the relation by length, shortest first and among movies of equal length alphabetically.


1 find all the movies that produced by disney studios in 1990 l.jpg

1. Find all the movies that produced by Disney Studios in 1990.

SELECT *

FROM Movie

WHEREStudioName = ‘Disney’ AND Year = 1990


Slide3 l.jpg

2. Modify the above query (Q1) to produce only the movie title and length

SELECT Title, Length

FROM Movie

WHEREStudioName = ‘Disney’ AND Year = 1990;


Slide4 l.jpg

3. Modify the above query (Q2) to produce a relation with attributes Name and Duration in place of title and length.

SELECT Title AS Name, Length AS Duration

FROM Movie

WHEREStudioName = ‘Disney’ AND Year = 1990;


Slide5 l.jpg

4. Modify the above query(Q3) to produced length in hours

SELECT Title AS Name, Length/60 AS LengthInHours

FROM Movie

WHEREStudioName = ‘Disney’ AND Year = 1990;


Slide6 l.jpg

5. Find all movies made after 1970 that are in black and white

SELECT Title

FROM Movie

WHEREYear > 1970 AND NOT inColor;


Slide7 l.jpg

6. Find the titles of the movies made by MGM Studios that either were made after 1970 or were less than 90 minutes long.

SELECT Title

FROM Movie

WHERE(Year > 1990 OR Length <90) AND StudioName = ‘MGM’;


Slide8 l.jpg

7. Search for all movies with a possessive (‘s) in their titles

SELECT Title

FROM Movie

WHERETitle LIKE ‘%’’s’;


Slide9 l.jpg

List the Disney movies of 1990 from the relation by length, shortest first and among movies of equal length alphabetically.

SELECT *

FROM Movie

WHEREstudioName = ‘Disney’ AND Year = 1990

ORDER BY Length, title;


  • Login