Write the needed sql to produce a list with the following columns: artist name, album title, [total number of tracks] the list will contain (as the last column) the total number of tracks per album. the list is also limited to only those artists that name begins with the letter "l." display the results in ascending order by artist name, then by album title. here is what the results should look like (the result should contain 28 rows):

Perform the following tasks: a. create a class named testclass that holds a single private integer field and a public constructor. the only statement in the constructor is one that displays the message “constructing”. write a main()function that instantiates one object of the testclass. save the file as testclass.cpp in the chapter 08 folder. run the program and observe the results. b. write another main()function that instantiates an array of 10 testclass objects. save the file as test class array.c . run this program and observe the results.