1. Engineering
  2. Computer Science
  3. using databasessql write the query table and editor found here...

Question: using databasessql write the query table and editor found here...

Question details

Using Databases(SQL) write the query:

TABLE and Editor found here: http://www.sqlitetutorial.net/tryit/

QUESTION:

Ludwig van Beethoven is concerned about his popularity. He has contacted Chinook Corp. to determine how well his music is selling in comparison to his rival, Wolfgang Amadeus Mozart. Once again, Chinook Corp. must ask for your help in solving this problem.

They attempted to get a competing database specialist to answer this question, but they were only able to solve part of the problem. You may notice that the tracks table contains no reference to the composer, only the trackID. This is the problem that the previous database specialist solved.

They wrote the following query:

SELECT *
FROM invoice_items AS II
JOIN tracks AS T ON T.TrackId = II.TrackID

As someone more adept with working with databases, you recognize that the results of this query can be used as if it were a table. You start out by executing the following query and observing the result. You see that you have all the data that you need to solve the problem.

SELECT *
FROM
(
SELECT *
FROM invoice_items AS II
JOIN tracks AS T ON T.TrackId = II.TrackID
)

So, are you able to answer Ludwig van Beethoven's question? Has he sold more copies of his tracks than his rival, Wolfgang Amadeus Mozart?

Select one:

True or False

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution