KEMBAR78
Module 3 Coding Assignment - Coursera | PDF | Data | Computer Science
Scribd
Upload
623 views1 page

Module 3 Coding Assignment - Coursera

The document is a quiz on Coursera about the Chinook Database that refers students to familiarize themselves with the entity relationship diagram and table/column names. It contains two multiple choice questions that ask the student to write SQL queries to return track names for a specific album using a subquery, and to return the title of the 8th track.

Uploaded by

ADNAN HASHMI
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
623 views1 page

Module 3 Coding Assignment - Coursera

The document is a quiz on Coursera about the Chinook Database that refers students to familiarize themselves with the entity relationship diagram and table/column names. It contains two multiple choice questions that ask the student to write SQL queries to return track names for a specific album using a subquery, and to return the title of the 8th track.

Uploaded by

ADNAN HASHMI
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

9/15/22, 6:11 PM Module 3 Coding Assignment | Coursera

Module 3 Coding Assignment


Back
Graded Quiz • 45 min

Due Sep 19, 12:29 PM IST

Item Navigation
Congratulations! You passed!
Grade received 100%
Module 3 Coding Assignment
Latest Submission Grade 100%
Quiz • 45To
minpass 70% or higher

Review Learning Objectives


Go to next item

Submit your assignment

Due  Sep 19, 12:29 PM IST


1.All of the questions in this quiz refer to the open source Chinook Database. Please familiarize yourself
Attempts  3 every 8 hours
with the ER diagram in order to familiarize yourself with the table and column names in order to write
accurate queries and get the appropriate answers.
Try again

Using a subquery, find the names of all the tracks for the album "Californication".

1 select t.Name
Receive 2grade
from Tracks t
3 where t.AlbumId = ( select a.AlbumId
To Pass  70% or higher
4 from Albums a
5 where a.Title = 'Californication')
6   Run
Your grade
7  
100% Reset

+-------------------+

| Name |

View Feedback
+-------------------+

| Around The World |

| Parallel
We keep your Universe |

highest score
| Scar Tissue |

| Otherside |

| Get On Top |

| Californication |

| Easily |

Like| Porcelain
Dislike |

Report an issue
| Emit Remmus |

| I Like Dirt |

+-------------------+

(Output limit exceeded, 10 of 15 total rows shown)

What is the title of the 8th track?

https://www.coursera.org/learn/sql-for-data-science/exam/cCOUv/module-3-coding-assignment/attempt?redirectToCover=true 1/1

You might also like