1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
ladessa [460]
3 years ago
6

Write a query that returns the Genres that I have purchased the most tracks of. I only care about genres that I've purchased at

least 10 tracks of. Please ignore any tracks costing a dollar or more (they are primarily TV shows). Please output two columns, the name of the genre ("Genre_Name") and the number of tracks purchased ("Number_Purchased"). Order from most purchases to least.
Computers and Technology
1 answer:
Murljashka [212]3 years ago
6 0

Answer:

<em>SQL Query</em>

///////////////////////////////////////////////////////////////////////////////////////////////////

select Genre_Name, Number_Purchased from Genre

INNER JOIN Tracks on Genre.Genre_Name = Tracks.Genre_Name

WHERE Number_Purchased >= 10 AND Tracks.price >= 1

ORDER BY Number_Purchased ASC;

Explanation:

First off, I selected the required columns from <em>Genre</em> Table.

Then I inner joined <em>Genre</em> table with <em>Tracks</em> table, to get the <em>price</em> of tracks of the corresponding Genres.

Then the required Where conditions are written, which includes one from the <em>Tracks</em> table.

Finally, the Order by statement is written by <em>Number_Purchased</em> column in ascending (ASC) order.

You might be interested in
Which is the correct description of the first act in a classical game story structure?
Reil [10]
The 3-act structure<span> is an old principle widely adhered to in storytelling today. It can be found in plays, poetry, novels, comic books, short stories, video games, and the movies. It was present in the novels of Conan Doyle, the plays of Shakespeare, the fables of Aesop, the poetry of Aristotle, and the films of Hitchcock. It’s older than Greek dramaturgy. Hollywood and Broadway use it well. It’s irrefutable and bullet-proof, so to speak.

so this means its more basic antagonist protagonist set-up even if the protagonist and antagonist are "CUBES"</span>
5 0
4 years ago
The Sentence below me is true. <br><br><br> The Sentence above me is false
AnnyKZ [126]
Ok........

Oh now I get it ! :)
4 0
3 years ago
Consumers may receive an​ e-mail, supposedly from their bank or credit card​ company, saying that their​ account's security has
Gnom [1K]

Answer:

Phishing

Explanation:

Phishing is a term used when a person fraudly or illegally uses a digital communication channel i.e. emails, by using the name of some reputed company or banks to get another person's personal data i.e login credentials, credit card details by telling them to log in the webpage given by them.

Phishing is one of the most happening cybercrimes which uses Email as their medium to reach the other person whose data they want to steal. Phishing is one of the terms of hacking.

6 0
3 years ago
Algorithms may be inefficient when used by a human brain.Answers:a. Algorithms can take in a relatively small amount of informat
Flauer [41]

Answer:

The correct answer is d. Algorithms may be inefficient when used by a human brain.

Explanation:

This is a situation typical of algorithms, since in order for them to work perfectly, the participation of people who carry out the necessary tests is required for the new creation to be useful in a specific field. Algorithms are logical operations determined according to a pattern, but the functioning of the human brain is in many cases different from a simple algorithm, since it associates situations and, depending on their complexity, also solves them.

3 0
3 years ago
Read 2 more answers
State one technique for overcoming external fragmentation in dynamic partitioning. Why is this technique of overcoming external
prisoha [69]

Compaction often gives solutions to the issues regarding external fragmentation.

One technique for overcoming external fragmentation in dynamic partitioning is

Compaction.

The reason why this technique of overcoming external fragmentation may be inefficient is because:

  • External fragmentation may need a lot of compaction and it is an expensive operation.

  • The use of contiguous allocation is often hard to fit processes into memory and also it is so difficult to grow or shrink the amount of memory allocated to a process.

  • Compaction only takes place when relocation is dynamic, and this also is expensive.

Compaction often shuffle memory notes or contents and then put or pile them up all in free memory and in one large block.

External fragmentation takes place when free memory is removed into small blocks.

Learn more from

brainly.com/question/23636593

4 0
2 years ago
Other questions:
  • What is the best approach to handling the expectation of privacy by employees in the event an investigation needs to be carried
    15·1 answer
  • Is Windows a:<br><br> A.operating system<br> B.software<br> C.hardware<br> D.input device
    12·1 answer
  • Explain the nature of documents that can be suitable for mergin
    12·1 answer
  • What is the purpose of citations?
    13·1 answer
  • Once you record your audio and click ok to save it what happens to the recording?
    9·1 answer
  • The smallest unit of storage is​
    15·1 answer
  • Write a program in which you input three numbers they canhave decimals so float values and the program gives you the minvalue ou
    8·1 answer
  • What is Accenture's role in Multi-party Systems?
    12·1 answer
  • Advantages of python programming language
    10·1 answer
  • Discusse five advantages of utilising DBMS over a file based system
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!