Using SQLite.

Write a single SQL statement to generate two rows of information: one row showing the number of tracks formatted in AAC media type, and the other row showing the number of tracks formatted in non-AAC media type. There should be two columns in the output: first column is named Media which has the value AAC or non-AAC; second column is named Tracks which shows the total number of tracks

Result:

Media	Tracks
AAC	255
non-AAC	3248

From Media Type table

Track Table

Table: -1 MediaType MediaTypeID Name Filter MPEG audio file Protected AA.. Protected MP... Purchased AA... AAC audio file Filter