reset password
Author Message
EASATRYAN
Posts: 14
Posted 12:45 Oct 08, 2017 |

Does the midterm include all the slides up to Data Manipulation?

toramoss
Posts: 13
Posted 13:38 Oct 08, 2017 |

Yes, it consists of material up to the current lecture, which is Data Manipulation.

EASATRYAN
Posts: 14
Posted 13:40 Oct 08, 2017 |

Thank you very much.

EASATRYAN
Posts: 14
Posted 17:46 Oct 11, 2017 | 
Describe this query:
SELECT artistName FROM Artists WHERE artistID IN (SELECT artistID FROM    Titles)

So far I understand this involves select artistname from artists  and select artistid from titles, I understand this reporst the name of all artists who have recorded a title. Can someone elaborate a little more so I get the picture on what this involves and how this happens. Thank you.