The answer is help because it helps you<span />
The answer to this question is, A. Cramming.
PLEASE MARK BRAINLIEST!! :)
age is a suitable variable name. It's descriptive and concise. Make sure it's lowercase.
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.
