The sign (*) represents mandatory fields
*Name
*Request SELECT CONCAT_WS(',',`dvd`.`Countries`) AS `COUNTRY` , COUNT( `dvd`.`Countries` ) AS `NUMBER` FROM `dvd` WHERE `dvd`.`Countries`!="" AND !(`dvd`.`Countries` LIKE "%,%") GROUP BY `dvd`.`Countries` UNION SELECT "MULTIPLE" , COUNT( `dvd`.`Countries` ) AS `NUMBER` FROM `dvd` WHERE `dvd`.`Countries`!="" AND (`dvd`.`Countries` LIKE "%,%") UNION SELECT 'N/A' , COUNT( `dvd`.`Countries` ) AS `NUMBER` FROM `dvd` WHERE `dvd`.`Countries`="" GROUP BY `dvd`.`Countries`
*Type Column chartLine chartArea chartPie chartPie chart
*Number
*Display NoYes