Question

In MySql, using Application MYSQL Workbench and the Chinook database, please answer the following: -- 12. SELECT the trackid, name and filesize (as shown in the bytes column) for all tracks that have a file size less than 2000000 and a GenreId of 1 or a file size less than 2000000 and a Genreid of 2 -- 13. Add a sort to the query from number 12 to sort by GenreID; -- 14. List all columns from the customer table where the customer Country is Brazil, Argentina, or Chile

Answer 1

Q12.

Query:

Select trackid, name, bytes as filesize
from track
where bytes < 2000000 and GenreId in (1,2)

Output:

Q13.

Select trackid, name, bytes as filesize
from track
where bytes < 2000000 and GenreId in (1,2)
Order by GenreId;

Output:

Q14.

Query:

Select *
from customer
where country in ("Brazil", "Argentina", "Chile")

Output:

(*Please up-vote. If any doubt, please let me know in the comments)