1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Materialised views query

Discussion in 'SQL PL/SQL' started by James Dae, Jul 25, 2019.

Tags:
  1. James Dae

    James Dae Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Netherlands
    Hi,

    New to creating queries in pl/sql. Can you please help me get the output from the attached file?

    The file is an excel worbook (SWIMPH_DATA_TABLE.xlsx) with 2 tabs, 1st tab is the table that I have, the 2nd tab is the output that I need.

    I need query to get that output.

    Thank you so much!
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,685
    Likes Received:
    376
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    How much SQL do you know? Certainly someone can post the solution and you can take it without knowing what it does and get THIS answer but be unable to apply the concepts to the next problem. You need to separate the values in the TEAM_PRODUCTS column before you can think of generating the output you posted. I'll take it this is a class assignment; if so then it's best to ask your instructor how this is done. If this is self-study then you haven't studied enough to tackle this one.

    Explain your situation much better than you have; help is available but no one will actually DO your assignment for you.