How to fetch data from a table which don't have a unique id
You want a pivot table (which isn't a inbuilt function in MySQL, but there are workarounds)

A rough example (I cant test this here):

select ID
   sum(if( sec = 'A', 1, 0)
       * points) as Sec A,
   sum(if( sec = 'O', 1, 0)
       * points) as Sec O,
   sum(if( sec = 'U', 1, 0)
       * points) as Sec U,
   sum(if( sec = 'B', 1, 0)
       * points) as Sec B,
   sum(if( sec = 'S', 1, 0)
       * points) as Sec S,
   sum(if( sec = 'T', 1, 0)
       * points) as Sec T,
   sum(if( sec = 'Y', 1, 0)
       * points) as Sec Y,
   sum(if( sec = 'Z', 1, 0)
       * points) as Sec Z
  from [schema].[table]
 group by id
;


NOTE: I've put section Y and Z as your additional sections as they don't appear in your example with what they are

If that doesn't work directly here's some external links with more detailed examples:


https://www.toadworld.com/platforms/mysql/w/wiki/6349.pivoting
http://modern-sql.com/use-case/pivot