Forum Discussion

NhatLinh_2012's avatar
NhatLinh_2012
Copper Contributor
Jun 28, 2024

Count value in column

Can you help me with this issue ?

I want to count the number of anime grouped by genres but I have 6 columns of genres. In output, I want to have a column for unique genre and a column for number of anime.

How can I do that?

 

  • Arshad440's avatar
    Arshad440
    Brass Contributor
    Jun 28, 2024
    That's less on information.please provide DDL for better Understanding

    Regards
  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Jun 28, 2024

     

    but I have 6 columns of genres.

    NhatLinh_2012 , sounds like bad database design and that causes always problems in analytics.

    The screenshot is much to small to see anything.

    Please post table design as DDL, some sample data as DML statement and the expected result. 

Resources