Answer:
Ok so basicly every time you see a question and you can answer it you press on the answer bar you type in your answers then you will automaticly get points depending on the question you answer, you need to get more than 5+ to ask a question of your own
Explanation:
<span>What is used to switch to Outline View?
the Insert tab
the status bar
the Mailings tab
the Page Layout bar</span>
Actually,
it is found in the VIEW TAB which is in the STATUS BAR. Coincidentally, all of
those tabs can be found in the status bar.
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.
