private void mainTable()
{
this.dataGridView1.DataSource = _context.GetQuery("SELECT person.id AS 'ID', fio AS 'ПІП', phone AS 'Телефон', city AS 'Місто', vacancy.name AS 'Вакансія', target_price AS 'Очікувана ЗП, $', vacancy.price AS 'Оклад на позиції', priceK AS 'ЗПК', score AS 'K вмінь', s.sum_c AS 'Стаж, р.' FROM person LEFT JOIN (SELECT id_person, sum(Floor(DATEDIFF(date_end, date_start))/365) sum_c FROM experience GROUP BY experience.id_person) s ON person.id = s.id_person LEFT JOIN vacancy ON person.id_vacancy = vacancy.id INNER JOIN rating ON person.id = rating.id_person ORDER BY rating.score AND rating.priceK DESC ");
}
