void MainWindow::on_VideoAutoB_clicked()
{
     qreal a;
     QString tmps;
     QList<qreal> AutoReal;

     QSqlQuery Auto1("SELECT Bench,Brend FROM Proc WHERE Name='"+ui->ProcNameCB->currentText()+"'");
     Auto1.first();

     if (Auto1.value(1).toString()=="Intel")
     {
     QSqlQuery query("SELECT Name,Bench FROM Video WHERE Chipset='nVidia'");
     while (query.next())
     {
         QString name = query.value(0).toString();
         a = (Auto1.value(0).toDouble()/query.value(1).toDouble());
         if ((Auto1.value(0).toDouble()<=4500) && (a>=1.8) && (a<=6)) {AutoVideo.append(name); AutoReal.append(a);}
         if ((Auto1.value(0).toDouble()>4500) && (Auto1.value(0).toDouble()<=8000) && (a>=1.5) && (a<=4.5)) {AutoVideo.append(name); AutoReal.append(a);}
         if ((Auto1.value(0).toDouble()>8000) && (a>=1.2) && (a<=2.5)) {AutoVideo.append(name); AutoReal.append(a);}
     }
     }
     if (Auto1.value(1).toString()=="AMD")
     {
     QSqlQuery query("SELECT Name,Bench FROM Video WHERE Chipset='AMD Radeon'");
     while (query.next())
     {
         QString name = query.value(0).toString();
         a = (Auto1.value(0).toDouble()/query.value(1).toDouble());
         if ((Auto1.value(0).toDouble()<=4500) && (a>=1.8) && (a<=6)) {AutoVideo.append(name); AutoReal.append(a);}
         if ((Auto1.value(0).toDouble()>4500) && (Auto1.value(0).toDouble()<=8000) && (a>=1.5) && (a<=4.5)) {AutoVideo.append(name); AutoReal.append(a);}
         if ((Auto1.value(0).toDouble()>8000) && (a>=1.2) && (a<=2.5)) {AutoVideo.append(name); AutoReal.append(a);}
     }
     }
     for (int i=AutoReal.length()-1;i>=0;i--)
     {
         for (int j=AutoReal.length()-2;j>=0;j--)
         {
             if(AutoReal[j]<AutoReal[j+1])
             {
                 qreal tmp=AutoReal[j];
                 AutoReal[j]=AutoReal[j+1];
                 AutoReal[j+1]=tmp;
                 tmps = AutoVideo[j];
                 AutoVideo[j]=AutoVideo[j+1];
                 AutoVideo[j+1]=tmps;
             }
         }
     }
     ui->VideoNameCB->setCurrentText(AutoVideo[(AutoVideo.length()/2)]);
     qDebug() << AutoVideo[AutoVideo.length()/2];
}