drop table if exists app;

create table if not exists app

(

    Version char(40),

    Description char(100),

    Latest_Rating char(10),

    Latest_Wine_version_tested char(10),

    Test_results int,

    Comments int,

    PRIMARY KEY (Version)

);

​

​

insert into app values

('1.0 (DOS)', 'Acrobat Reader 1.0 for DOS','Gold','1.5.12',4,0),

('10.x','Adobe Reader X','Silver','1.7.55',18,0),

('11.x','Introduces Extended tools, improved PDF Annotator, improved eSignatures.','Silver','3.11',26,0),

('2.x','Acrobat Reader 2','Garbage','5.0',3,0),

('3.x (16-bit)','Acrobat Reader 3 for Windows 3.1','Bronze','1.3.16',7,0),

('3.x (32-bit)','Acrobat Reader 3 for Windows 95 and later','Platinum','1.9.14',10,0),

('4.x','Acrobat Reader 4','Platinum','1.9.14',8,0),

('5.x','Acrobat Reader 5','Gold','1.9.14',6,0),

('6.x','Adobe Reader 6 for Windows 98SE, NT4 SP6 and later','Platinum','1.9.14',5,0),

('7.x','Adobe Reader 7 for Windows NT4 SP6 and later','Silver','5.0',7,0),

('8.x','Adobe Reader 8.  Later versions include support for Windows Vista.','Platinum','1.9.14',14,0),

('9.x','Adobe Reader 9','Platinum','2.0.2',9,0),

('DC','Adobe Acrobat Reader DC for Windows 7 and later','Gold','7.0',16,17);

​

select * from app order by cast(version as signed), substring(version,-1);

​