Data Model | List of Queries | Experiment data
Q1 | SELECT DISTINCT p.name , e.name FROM project p
LEFT JOIN work t ON p.proyId = w.proyId LEFT JOIN empoloyee e ON w.empId = e.empId WHERE e.hourSalary <= 20 OR e.hourSalary IS NULL ORDER BY p.name ASC , e.name ASC |
Q2 | SELECT e.name , w.month , w.hours , p.name FROM empoloyee e
LEFT JOIN work t ON w.empId = e.empId LEFT JOIN project p ON p.proyId = w.proyId WHERE w.hours > 50 ORDER BY e.name ASC , w.month ASC |
Q3 | SELECT e.name , p.name , SUM( hours ) FROM empoloyee e
INNER JOIN work t ON e.empId = w.empId INNER JOIN project p ON w.proyId = p.proyId GROUP BY e.name , p.name HAVING ( SUM( hours ) < @hours ) OR ( SUM( hours ) IS NULL) ORDER BY p.name ASC , e.name ASC |
Q4 | SELECT p.name , SUM( hours ) FROM project p
INNER JOIN work t ON p.proyId = w.proyId LEFT JOIN empoloyee e ON w.empId = e.empId WHERE ( e.level <> 'B' ) OR ( e.level IS NULL) GROUP BY p.name HAVING SUM( horas ) > @hours ORDER BY p.name ASC |
The following data includes the mutation scores for each test case, organized as follows:
Data is in CSV format (separator is ;)
Group;Subject;Query;Technique;Score A;1;Q1;CC;0.9326 A;1;Q2;OT;0.8491 A;1;Q3;CC;0.6720 A;1;Q4;OT;0.8934 A;1;Q5;CC;0.7711 A;1;Q6;OT;0.9247 A;2;Q1;CC;0.9326 A;2;Q2;OT;0.8396 A;2;Q3;CC;0.8160 A;2;Q4;OT;0.8852 A;2;Q5;CC;0.8554 A;2;Q6;OT;0.9140 A;3;Q1;CC;0.8652 A;3;Q2;OT;0.8491 A;3;Q3;CC;0.7280 A;3;Q4;OT;0.8770 A;3;Q5;CC;0.8313 A;3;Q6;OT;0.8925 A;4;Q1;CC;0.9326 A;4;Q2;OT;0.8679 A;4;Q3;CC;0.6800 A;4;Q4;OT;0.8525 A;4;Q5;CC;0.8434 A;4;Q6;OT;0.9247 A;5;Q1;CC;0.9213 A;5;Q2;OT;0.8774 A;5;Q3;CC;0.9360 A;5;Q4;OT;0.8197 A;5;Q5;CC;0.9157 A;5;Q6;OT;0.8602 A;6;Q1;CC;0.9101 A;6;Q2;OT;0.8868 A;6;Q3;CC;0.9120 A;6;Q4;OT;0.9016 A;6;Q5;CC;0.9157 A;6;Q6;OT;0.8925 A;7;Q1;CC;0.9326 A;7;Q2;OT;0.8113 A;7;Q3;CC;0.8480 A;7;Q4;OT;0.9098 A;7;Q5;CC;0.8795 A;7;Q6;OT;0.9032 A;8;Q1;CC;0.9326 A;8;Q2;OT;0.8113 A;8;Q3;CC;0.9360 A;8;Q4;OT;0.8033 A;8;Q5;CC;0.9157 A;8;Q6;OT;0.8817 A;9;Q1;CC;0.9326 A;9;Q2;OT;0.8679 A;9;Q3;CC;0.8720 A;9;Q4;OT;0.8934 A;9;Q5;CC;0.9036 A;9;Q6;OT;0.9140 A;10;Q1;CC;0.8989 A;10;Q2;OT;0.8019 A;10;Q3;CC;0.7200 A;10;Q4;OT;0.8115 A;10;Q5;CC;0.8072 A;10;Q6;OT;0.8495 B;11;Q1;OT;0.8202 B;11;Q2;CC;0.9057 B;11;Q3;OT;0.7280 B;11;Q4;CC;0.7541 B;11;Q5;OT;0.7470 B;11;Q6;CC;0.9140 B;12;Q1;OT;0.8652 B;12;Q2;CC;0.8302 B;12;Q3;OT;0.7680 B;12;Q4;CC;0.8934 B;12;Q5;OT;0.7470 B;12;Q6;CC;0.9247 B;13;Q1;OT;0.7303 B;13;Q2;CC;0.8962 B;13;Q3;OT;0.7440 B;13;Q4;CC;0.8361 B;13;Q5;OT;0.7831 B;13;Q6;CC;0.8710 B;14;Q1;OT;0.8539 B;14;Q2;CC;0.8491 B;14;Q3;OT;0.8480 B;14;Q4;CC;0.9016 B;14;Q5;OT;0.7952 B;14;Q6;CC;0.9462 B;15;Q1;OT;0.8876 B;15;Q2;CC;0.8962 B;15;Q3;OT;0.8240 B;15;Q4;CC;0.8607 B;15;Q5;OT;0.8675 B;15;Q6;CC;0.9247 B;16;Q1;OT;0.8202 B;16;Q2;CC;0.8962 B;16;Q3;OT;0.8160 B;16;Q4;CC;0.9262 B;16;Q5;OT;0.8675 B;16;Q6;CC;0.9247 B;17;Q1;OT;0.9326 B;17;Q2;CC;0.8774 B;17;Q3;OT;0.8240 B;17;Q4;CC;0.8525 B;17;Q5;OT;0.8193 B;17;Q6;CC;0.9355 B;18;Q1;OT;0.8539 B;18;Q2;CC;0.8585 B;18;Q3;OT;0.7520 B;18;Q4;CC;0.9180 B;18;Q5;OT;0.8072 B;18;Q6;CC;0.9032 B;19;Q1;OT;0.8090 B;19;Q2;CC;0.8868 B;19;Q3;OT;0.7200 B;19;Q4;CC;0.9262 B;19;Q5;OT;0.7349 B;19;Q6;CC;0.9032 B;20;Q1;OT;0.9101 B;20;Q2;CC;0.8679 B;20;Q3;OT;0.6640 B;20;Q4;CC;0.9262 B;20;Q5;OT;0.8193 B;20;Q6;CC;0.9140