reset password
Author Message
stariq2
Posts: 5
Posted 17:10 Nov 02, 2011 |

In query no. 3 of homework ... i wasn't sure how to join employees and region tables ...   can we discuss about it here?

cysun
Posts: 2935
Posted 18:43 Nov 02, 2011 |

Sure. And I'll start.

If you lost points for #3, chances are you were querying the wrong type of manager. You can find department managers by looking at the manager_id column in the departments table.

For #9, notice that the problem asks for people who have worked for more than one "department", not just more than one job position.

stariq2
Posts: 5
Posted 18:59 Nov 02, 2011 |

oh thanks a lot .. I figured out both of them.