Course Content
Data Manipulation using SQL
Data Manipulation using SQL
Challenge: the Biggest Album
Task
Find the album's title (title
) with a maximum number of songs (count id
s). If there are multiple answers, select the first one from sorted in the lexicographical order.
Task
Find the album's title (title
) with a maximum number of songs (count id
s). If there are multiple answers, select the first one from sorted in the lexicographical order.
Everything was clear?
Challenge: the Biggest Album
Task
Find the album's title (title
) with a maximum number of songs (count id
s). If there are multiple answers, select the first one from sorted in the lexicographical order.
Task
Find the album's title (title
) with a maximum number of songs (count id
s). If there are multiple answers, select the first one from sorted in the lexicographical order.
Everything was clear?
Challenge: the Biggest Album
Task
Find the album's title (title
) with a maximum number of songs (count id
s). If there are multiple answers, select the first one from sorted in the lexicographical order.
Task
Find the album's title (title
) with a maximum number of songs (count id
s). If there are multiple answers, select the first one from sorted in the lexicographical order.
Everything was clear?
Task
Find the album's title (title
) with a maximum number of songs (count id
s). If there are multiple answers, select the first one from sorted in the lexicographical order.