• 2022-06-19
    case函数的格式正确的是( )
    A: case(depth<=70 "Shallow" depth>70 AND depth<=300 "Mid" depth>300 "Deep")
    B: case(depth<=70, "Shallow", depth>70 AND depth<=300, "Mid", depth>300, "Deep")
    C: case(depth<=70, "Shallow", depth>70 && depth<=300, "Mid", depth>300, "Deep")
    D: case(depth<=70, "Shallow", depth>70 && depth<=300, "Mid", depth>300, "Deep")