N3aT4wWU

1CREATE TABLE IF NOT EXISTS `server` (
2  `name` varchar(80) NOT NULL,
3  `field` varchar(80) NOT NULL,
4  `value` varchar(200) NOT NULL
5);
6	
7CREATE TABLE IF NOT EXISTS `event` (
8  `name` varchar(80) NOT NULL,
9  `field` varchar(80) NOT NULL,
10  `value` varchar(80) NOT NULL
11);
12	
13Date         Number patched
142017-11-14   2
152017-11-04   1
16	
17Select date_format(d.val, '%Y-%m-%d') as 'Date', COUNT(distinct 
18date_format(d.val, '%Y-%m-%d')) as 'Number' 
19FROM (
20    Select b.serv,b.val 
21    FROM (
22        Select serv,val FROM (
23          Select name as serv, value as val FROM event 
24          where field='server_vers' and 
25          value!='None' 
26          order by serv ASC, 
27          val DESC LIMIT 18446744073709551615) a 
28        group by a.serv) b, 
29        server c 
30    where b.serv = c.name and c.field = 'OS' and c.value = 'Fedora'
31) d group by d.val;