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
If you are viewing a webpage with customized or regenerated content, such as updated stock quotes, what type of webpage are you
horsena [70]

Answer:

Dynamic

Explanation:

A dynamic web page is a type of web page that shows different and diverse content each time it's viewed. For instance, the webpage may adjust with every passing time of day, it might also change according to the different preference of each user that accesses the webpage, or the kind of user interaction.

5 0
4 years ago
What are some similarity's between NES console and consoles today
blondinia [14]

Answer:

Old game consoles

New game consoles

Old games consoles like the NES, SNES, the SEGA Genesis were manufactured during the 1970's This generation started in the first and ends in the fifth

New game 3-D consoles like the PS3, X-Box 360 and the Wii U were manufactured during the late 90s to right now. This generation started in the sixth and ends at the eighth.

Facts

They have introduce a lot of game genres and characters like the Mario bros, The Legend of Zelda series, The Tetris game, and Sonic the Hedgehog series.

Genres like platformers and side scrollers were introduced in the 2-D era

New game consoles has introduce game genres like First Person Shooters. Games like Call of Duty and Halo are examples

The answer

The differences between an old console and a new console is not only the modeling of either the game console, but the functional properties and the way it operates. From each generation , there are about eight generations of consoles right now

The difference between an old generation of consoles and a new genration of console

Sources

http://www.answers.com/Q/What_is_the_difference_between_the_old_games_consoles_and_the_new_games_consoles

Pictures and more facts

The X-Box sucessor, the X-Box 360 was released in November 22, 2005 in the United States. Games like Halo and Call of Duty are the games that introduced really good First-Person Shooters

The Playstation 1, PSx, or the PS1 was made in September 9th 1995 in North America. The games that was in for the playstation is the famous Crash Bandicoot and Spyro the Dragon series and a few 2-d games.

The second picture the Super Nintendo Entertainment System or the SNES, was release to America in 1991 and is the sucessor of the NES

The games that was in the system was Super Mario World 1-2, The legend of zelda 3, which were one of the best selling games on the system

The first picture the Nintendo Entertainment System or the NES, that was released to America in 1985 and it was the best selling console at its time.

The games it introduce was of course Super Mario Bros 1-3, The Legend of Zelda 1-2

The third and last picture is the SEGA Overdrive or SEGA Genesis was releases to America in 1989 and rivaled with the SNES during the time.

Games that was with the system was SEGA's blue mascot Sonic the Hedgehog 1-3 and Knuckles, Teenage Mutant Ninja Turtles

PS1 fact

Even though the PS1 has its 2-D games, it also has 3-D games like the Crash Bandicoot and Spyro series made by Naughty Dog, who also did the Last of us game

Explanation:

the similarities are they both play games they both load some type of disk etc.

3 0
3 years ago
Read 2 more answers
Compare the two types of formatting that IDE devices must go through. What is the primary difference between the two?
Andrei [34K]
A quick format<span> changes the file system while the </span>full format<span> also checks the </span>drive for bad sectors.  <span>The scan for bad sectors is the reason why the Full </span>format<span> takes twice as long as the </span>Quick format<span>. If you choose the </span>Quick format<span> option, the </span>format<span> removes address files from the partition, but does not scan the disk for bad sectors.</span>
7 0
3 years ago
Read 2 more answers
How might the design be changed so that additional copies of print statements would not be needed?
bogdanovich [222]

A design be altered so that additional copies of print statements would not be needed by changing the format spring.

<h3>What is the aim of a print statement?</h3>

The PRINT statement is known to be often sent data so that it is taken to the display terminal or to another kind of print unit.

Note that A design be altered so that additional copies of print statements would not be needed by changing the format spring.

Learn more about design from

brainly.com/question/1020696

#SPJ1

5 0
2 years ago
why is it important for you to understand and describe the internal and external components of a computer in the workplace​
zhannawk [14.2K]

Hi! I have been troubleshooting and building PCs all my life and I find it very important to know the the internal core components of a PC and how they function that way when errors occur you can attempt to fix the problem.

Ex1: Lets say your BIOS identifies a problem with a RAM slot you would be able to know that your RAM slot is either shorted or there is a problem with the RAM stick you inserted.

Ex2: Now your monitor is flashing and turning colors randomly. You could make an inference that either your monitor is prongs are broken, your cable prongs could be bent, your cable might not be plugged in all the way, or your external or integrated GPU is toast.

Hope this might've showed you something

Aaron

7 0
3 years ago
Other questions:
  • Under what key category do page up and page down keys fall?
    15·1 answer
  • Antonio’s computer is hung up. which trio of keys should he press to restart his computer?
    7·2 answers
  • 1. The number of major solutions for preventing workplace hazards is
    14·1 answer
  • When starting a new job, the form you complete to determine how much tax to withhold from your paycheck is called the
    9·1 answer
  • Function countValues = CreateArray(endValue) % endValue: Ending value of countValues
    7·1 answer
  • H&amp;R Block's stated purpose is: to be the leading global consumer tax company bringing tax and related solutions to clients y
    15·1 answer
  • )In a graph represented by adjacency matrix u can find all the neighbours of a given vertices in ____Operations
    6·1 answer
  • Florida law requires every child blank years of age or younger use a crash tested federally be approved child restraint device
    5·2 answers
  • Swapping Order of Vowels Write a program to swap the order of the vowels in a given word. For example, if the word is programmin
    10·1 answer
  • A restaurant recorded the ages of customers on two separate days. You are going to write a program to compare the number of cust
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!