Practical Questions

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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## 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

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.

SELECT *

FROM Movie

WHERE StudioName = ‘Disney’ AND Year = 1990

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

SELECT Title, Length

FROM Movie

WHERE StudioName = ‘Disney’ AND Year = 1990;

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

WHERE StudioName = ‘Disney’ AND Year = 1990;

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

SELECT Title AS Name, Length/60 AS LengthInHours

FROM Movie

WHERE StudioName = ‘Disney’ AND Year = 1990;

SELECT Title

FROM Movie

WHERE Year > 1970 AND NOT inColor;

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

SELECT Title

FROM Movie

WHERE Title LIKE ‘%’’s’;

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

SELECT *

FROM Movie

WHERE studioName = ‘Disney’ AND Year = 1990

ORDER BY Length, title;