the sql portion of assignment