I fount the following sites explained clearly about defect triaging and felt worth to share it my blog to help others. This question was been asked in many interviews as well "What is defect triaging? And how do you handle it?". Defect Triaging Meeting: http://www.testingdiaries.com/defect-triage-meeting/#:~:text=Defect%20Triage%20Meetings%20are%20project,are%20defined%20for%20the%20bugs. Defect Triage: https://www.guru99.com/bug-defect-triage.html#:~:text=Defect%20triage%20is%20a%20process,and%20priority%20of%20new%20defects. Priority Vs Severity: https://www.guru99.com/defect-severity-in-software-testing.html https://www.softwaretestinghelp.com/how-to-set-defect-priority-and-severity-with-defect-triage-process/
SQL_Query : In this MySQL challenge, your query should return the names of the people who are reported to (excluding null values), the number of members that report to them, and the average age of those members as an integer. The rows should be ordered by the names in alphabetical order. Your output should look like the following table . Solution : SELECT ReportsTo , count ( ReportsTo ) as Members , round ( avg ( Age ), 0 ) as 'Average Age' FROM maintable_MS9H0 Where ReportsTo is not null Group by ReportsTo order by ReportsTo or SELECT ReportsTo , COUNT ( FirstName ) as Members , ROUND ( AVG ( Age )) as "Average Age" FROM maintable_MS9H0 WHERE ReportsTo IS NOT NULL GROUP BY ReportsTo SQL_Query: In this MySQL challenge, the ta...