locked
SQL SELECT Query Question RRS feed

  • Question

  • Hello Fellow Members:
    I would like your help resolving this issue. I need to write a Select Query to do as the following table below? Is this possible to do and how the Query would look like?

    Thank You

    Tarek

    Deal ID Amount Deal Owner Owner 1 Owner 2 Owner 3 Owner Count
    1 10 Jack John Steve
    2 50 Mona Dina
    3 30 Mike Sabrina Leo Tamara 4
    4 40 Don
    Deal Owner Amount Deal ID
    Jack 10 1
    John 10 1
    Steve 10 1
    Mona 50 2
    Dina 50 2
    Mike 30 3
    Sabrina 30 3
    Leo 30 3
    Tamara 30 3
    Don 40 4


    Saturday, December 26, 2020 5:27 PM