Write sql statements for the ten queries

Assignment Help PL-SQL Programming

Reference no: EM13689589

Consider the following database schema:

Artists (artistID: int, name: varchar (255))

SimilarArtists (artistID: int, simArtistID: int, weight: int)

Albums (albumID: int, artistID: int, name: varchar (255))

Tracks (trackID: int, artistID: int, name: varchar (255), length: int)

TrackLists (albumID: int, trackID: int, trackNum: int)

All primary keys are underlined. All foreign keys have the same name as the primary key that they are referencing. When asking about the similarity of one Artist to another, you can safely assume that the pair of Artists will only appear in one tuple in the SimilarArtists table.

Write SQL statements for the following ten queries:

1. Find the names of all Tracks that are more than 10 minutes (600,000 ms) long. Result: (name: varchar(255))

2. Find the names of all Artists who have recorded a self-titled Album (the name of the Album is the same as the name of the Artist). Result: (name: varchar(255))

3. Find the names of all Artists who have recorded an Album on which the first track is named "Intro". Result: (name: varchar(255))

4. Find the names of all Artists who are more similar to Mogwai than to Nirvana (meaning the weight of their similarity to Mogwai is greater). Result: (name: varchar(255))

5. Find the names of all Albums that have more than 30 tracks. Result: (name: varchar(255))

6. Find the names of all Artists who do not have a similarity rating greater than 5 to any other Artist. Result: (name: varchar(255))

Reference no: EM13689589

Questions Cloud

Calculate the percent ionization of the benzoate ion : Calculate the percent ionization of the benzoate ion.

What is the minimum number of moles of h2so4 : What is the minimum number of moles of H2SO4 that must react to form 1.7752 moles of manganes (II) sulfate?

What was the mass percent of ascorbic acid : What was the mass percent of ascorbic acid in the sample?

Explain how and why you would schedule an appointment : Explain how and why you would schedule an appointment

Write sql statements for the ten queries : Write SQL statements for the ten queries - find the names of all Tracks that are more than 10 minutes (600,000 ms) long. Result: (name: varchar(255))

Analyze principles of the 360 degree performance assessment : Analyze the principles of the 360 degree performance assessment and explain how it should be implemented in the organizations - When mentioning any information from any source, mention the source at the beginning of the paragraph or at the end of it.

Why world trade : Explain to your 14 year old sibling and your 90 year old grandfather why the US should promote world trade.

What are the differences between investing : What are the differences between investing $15,000 at 9% p.a. for 15 years when compounded yearly, quarterly, monthly, daily, and continuously? Ignore the effect of leap years.

Productions functions exhibit increasing return of scale : Are the following productions functions exhibit increasing/constant/decreasing return to scale? Given that the wage rate for per unit of labor is $10 and rental rate for unit of capital is $10, according to these functions, are the firms operate in e..

User Account

All Pages