Show me the title of album id 1?
select t1.title from album as t1 join artist as t2 on t1.artistid = t2.artistid where t1.albumid = 1
Show me the name of artist with artist id 3?
select name from artist where artistid = 3
Show me the names of all artist?
select name from artist
Show me the list of all id and names of all artists that have at least 3 albums in alphabetical order?
select t2.name, t1.artistid from album as t1 join artist as t2 on t1.artistid = t2.artistid group by t1.artistid having count ( * ) > = 3 order by t2.name