Taking data and instructions from a user, processing the data as per instructions, and displaying or storing the processed data, are the four major functions of a computer. These functions are also known as the input function, process function, output function, and storage function, respectively.

5 0

3 years ago

Employees often attend trainings and read policies. They endure these, but do not internalize them. What should be your first st

Vlada [557]

Answer:

I would say b but if I'm wrong take the point back

7 0

1 year ago

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

Murljashka [212]

Answer:

SQL Query

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

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 Genre Table.

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

Then the required Where conditions are written, which includes one from the Tracks table.

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

6 0

2 years ago