Consider the tables provided below and answer the following SQL questions: Table 1: Artist Table 2:...

Transcribed Image Text:

Consider the tables provided below and answer the following SQL questions: Table 1: Artist Table 2: Track (Traid - means TrackID) traid title 1 Great Big Words 1 This Pretty Planet 2 Cat's in the Cradle id 1 2 C. name Tom Chapin Harry Chapin d. Questions: a. Write insert statements to enter first two records into Track table as shown in above figure. e. artist b. Display a list that presents the data contained in Track Table sorted by title in ascending order. 1 1 2 Display traid and title for tracks that have 'Pretty' word in middle of the title. Display the name of the artists that belong to the title starting with letter 'C'. Display number (count) of tracks for each artist. Consider the tables provided below and answer the following SQL questions: Table 1: Artist Table 2: Track (Traid - means TrackID) traid title 1 Great Big Words 1 This Pretty Planet 2 Cat's in the Cradle id 1 2 C. name Tom Chapin Harry Chapin d. Questions: a. Write insert statements to enter first two records into Track table as shown in above figure. e. artist b. Display a list that presents the data contained in Track Table sorted by title in ascending order. 1 1 2 Display traid and title for tracks that have 'Pretty' word in middle of the title. Display the name of the artists that belong to the title starting with letter 'C'. Display number (count) of tracks for each artist.

Answer rating: 100% (QA)

Here are the SQL queries to address your questions a Insert statements to enter the first t... View the full answer