Question

4-16

In MySql, using Application MYSQL Workbench and the Chinook database, please write a query to answer this? --

16. Display the ablumid, the title, and the length of each title for each row in the album table. Number 16 - use LENGTH function

I just need to add the Lenghth function to this answer:

SELECT ArtistId, SUBSTRING(ArtistName, 1, 5) AS ArtistName FROM Artist;

Answer 1

SELECT ablumid, title, LEN(title) AS album_title_length FROM album;

This will give you the length of the titles from the table album..

SELECT ArtistId, SUBSTRING(ArtistName, 1, 5) AS ArtistName FROM Artist;

This is your query, from this what i understood I am you need to add length functiok to artist name..

SELECT artistid, LEN(artistname) AS length_ArtistName from artist;

If i am wrong, plea se explain your query in comment section, i will give you the query.. Thn is is from my understandingof the problem