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.
<span>The general who directed the project responsible for the "Fat Man” graduated from : West point
The fat man project refer to the codename of the atomic bomb that were dropped on top of Nagasaki in 1945. Although by dropping the bomb we did made japan surrender from the world war II, we killed more than 50,000 people with a single bombHope this helps. Let me know if you need additional help!</span>
