reset password
Author Message
TLizandro
Posts: 8
Posted 14:11 Mar 25, 2017 |

Anyone get a good grade in the midterm or get 5-10 right? I need help finding out what I did wrong, any help would be great thanks!

Arnav98
Posts: 48
Posted 14:21 Mar 25, 2017 |

Where did you see your grade ?

Alewin98
Posts: 3
Posted 15:09 Mar 25, 2017 |

You see your grade by clicking on midterm in the section student's home.

Alewin98
Posts: 3
Posted 15:22 Mar 25, 2017 |

5) the part in the on( ) tells you what you are looking for, specifically the part tr.lengthseconds < 200, and in the where clause it contains NULL and talks about tracks. So the query is

finding titles that don't have any tracks where tr.lengthseconds < 200.

6)  you use MAX() and MIN() for this. its talking about tracks so you also use lengthseconds, so you just subtract the max by min

7)  you're looking for members of Sonata, so you have to join the members table to xrefartistsmembers table and join that to artists, then once you do that, filter to the artist you are finding and order by length of last name

Alewin98
Posts: 3
Posted 15:26 Mar 25, 2017 |

what did you put for numbers 8-10? I can try to help you find out what you did wrong.