Q&A about the site for Muslims, experts in Islam, and those interested in learning more about Islam
SELECT c.Id AS CommentId, c.PostId AS PostId, c.Text AS CommentText, c.CreationDate, p.Title AS PostTitle, p.Body AS PostBody, CASE WHEN c.Text LIKE '%completeness%' OR c.Text LIKE '%functionality%' OR c.Text LIKE '%accurate%' OR c.Text LIKE '%exact%' OR c.Text LIKE '%perfect%' OR c.Text LIKE '%precise%' OR c.Text LIKE '%proper%' OR c.Text LIKE '%exactness%' OR c.Text LIKE '%accuracy%' OR c.Text LIKE '%clarity%' OR c.Text LIKE '%correctness%' OR c.Text LIKE '%perfection%' OR c.Text LIKE '%nicety%' OR c.Text LIKE '%unnecessary steps%' OR c.Text LIKE '%fulness%' OR c.Text LIKE '%wholeness%' OR c.Text LIKE '%absoluteness%' THEN 'Functional Suitability' WHEN c.Text LIKE '%reliable%' OR c.Text LIKE '%fault tolerant%' OR c.Text LIKE '%recoverability%' OR c.Text LIKE '%availability%' THEN 'Reliability' WHEN c.Text LIKE '%response time%' OR c.Text LIKE '%responsiveness%' OR c.Text LIKE '%throughput%' OR c.Text LIKE '%latency%' OR c.Text LIKE '%scalability%' OR c.Text LIKE '%reaction time%' OR c.Text LIKE '%latency period%' OR c.Text LIKE '%time interval%' OR c.Text LIKE '%interval%' OR c.Text LIKE '%processing time%' OR c.Text LIKE '%battery%' OR c.Text LIKE '%battery drainage%' OR c.Text LIKE '%memory usage%' OR c.Text LIKE '%CPU cycle%' OR c.Text LIKE '%storage%' OR c.Text LIKE '%capacity%' OR c.Text LIKE '%communication bandwidth%' THEN 'Performance' WHEN c.Text LIKE '%user-friendly%' OR c.Text LIKE '%ease of use%' OR c.Text LIKE '%easy to understand%' OR c.Text LIKE '%accessible%' OR c.Text LIKE '%appealing%' OR c.Text LIKE '%aesthetical appealing%' OR c.Text LIKE '%guidelines%' OR c.Text LIKE '%instruction%' OR c.Text LIKE '%direction%' OR c.Text LIKE '%suggestion%' OR c.Text LIKE '%advice%' OR c.Text LIKE '%easy to remember steps%' OR c.Text LIKE '%controllability%' OR c.Text LIKE '%error protection%' OR c.Text LIKE '%ability%' OR c.Text LIKE '%secure%' OR c.Text LIKE '%correct%' OR c.Text LIKE '%use of color%' OR c.Text LIKE '%graphical design%' THEN 'Usability' WHEN c.Text LIKE '%immunity%' OR c.Text LIKE '%safety%' OR c.Text LIKE '%integrity%' OR c.Text LIKE '%accountability%' OR c.Text LIKE '%authenticating%' THEN 'Security' WHEN c.Text LIKE '%similarity%' OR c.Text LIKE '%agreement%' OR c.Text LIKE '%fellow feeling%' THEN 'Compatibility' WHEN c.Text LIKE '%screen fields%' OR c.Text LIKE '%tables%' OR c.Text LIKE '%transaction volumes%' OR c.Text LIKE '%report formats%' OR c.Text LIKE '%installed by an end user%' OR c.Text LIKE '%compactness%' OR c.Text LIKE '%convenience%' OR c.Text LIKE '%handiness%' OR c.Text LIKE '%lightness%' OR c.Text LIKE '%replaceability%' THEN 'Portability' WHEN c.Text LIKE '%friendly%' OR c.Text LIKE '%wonderful%' OR c.Text LIKE '%reliable%' OR c.Text LIKE '%delightful%' OR c.Text LIKE '%first-class%' OR c.Text LIKE '%first-rate%' OR c.Text LIKE '%super%' OR c.Text LIKE '%fantastic%' OR c.Text LIKE '%incredible%' OR c.Text LIKE '%heavenly%' OR c.Text LIKE '%fabulous%' OR c.Text LIKE '%fab%' OR c.Text LIKE '%fantabulous%' OR c.Text LIKE '%awesome%' OR c.Text LIKE '%mind-blowing%' OR c.Text LIKE '%sparkling%' OR c.Text LIKE '%brilliant%' OR c.Text LIKE '%capital%' OR c.Text LIKE '%champion%' OR c.Text LIKE '%extremely good%' OR c.Text LIKE '%contentment%' OR c.Text LIKE '%gratification%' OR c.Text LIKE '%fulfillment%' OR c.Text LIKE '%joy%' OR c.Text LIKE '%enjoyment%' OR c.Text LIKE '%functionality%' OR c.Text LIKE '%fitness%' OR c.Text LIKE '%adequacy%' OR c.Text LIKE '%neatness%' OR c.Text LIKE '%convenience%' OR c.Text LIKE '%utility%' OR c.Text LIKE '%use%' OR c.Text LIKE '%value%' OR c.Text LIKE '%worth%' OR c.Text LIKE '%merit%' OR c.Text LIKE '%success%' OR c.Text LIKE '%benefits%' OR c.Text LIKE '%advantages%' OR c.Text LIKE '%helpfulness%' OR c.Text LIKE '%good avail%' OR c.Text LIKE '%help%' OR c.Text LIKE '%assistance%' OR c.Text LIKE '%confident%' OR c.Text LIKE '%believe%' OR c.Text LIKE '%faith%' OR c.Text LIKE '%safe%' OR c.Text LIKE '%assurance%' OR c.Text LIKE '%reliance%' OR c.Text LIKE '%safekeeping%' OR c.Text LIKE '%protection%' OR c.Text LIKE '%care%' OR c.Text LIKE '%guardianship%' OR c.Text LIKE '%fulfillment%' OR c.Text LIKE '%relief%' OR c.Text LIKE '%trust%' OR c.Text LIKE '%secure%' OR c.Text LIKE '%quality%' THEN 'Satisfaction' WHEN c.Text LIKE '%waste%' OR c.Text LIKE '%miss%' OR c.Text LIKE '%problem%' OR c.Text LIKE '%wrong%' OR c.Text LIKE '%accuracy%' OR c.Text LIKE '%completeness%' OR c.Text LIKE '%precision%' OR c.Text LIKE '%exactness%' OR c.Text LIKE '%validity%' OR c.Text LIKE '%authority%' OR c.Text LIKE '%reliability%' OR c.Text LIKE '%perfection%' OR c.Text LIKE '%faithfulness%' OR c.Text LIKE '%closeness%' OR c.Text LIKE '%truth%' OR c.Text LIKE '%truthfulness%' OR c.Text LIKE '%authenticity%' OR c.Text LIKE '%realism%' OR c.Text LIKE '%fairness%' OR c.Text LIKE '%rigour%' THEN 'Effectiveness' WHEN c.Text LIKE '%defense%' OR c.Text LIKE '%shielding%' OR c.Text LIKE '%shelter%' OR c.Text LIKE '%preservation%' OR c.Text LIKE '%conservation%' OR c.Text LIKE '%safe keeping%' OR c.Text LIKE '%safeguard%' OR c.Text LIKE '%safety%' OR c.Text LIKE '%support%' OR c.Text LIKE '%providence%' OR c.Text LIKE '%dependability%' THEN 'Freedom of Risk' WHEN c.Text LIKE '%slow%' OR c.Text LIKE '%limit%' OR c.Text LIKE '%fast%' OR c.Text LIKE '%lock%' OR c.Text LIKE '%unhurried%' OR c.Text LIKE '%leisurely%' OR c.Text LIKE '%moderate%' OR c.Text LIKE '%deliberate%' OR c.Text LIKE '%steady%' OR c.Text LIKE '%slow moving%' OR c.Text LIKE '%time to complete a task%' THEN 'Efficiency' ELSE 'Other' END AS Aspect FROM Comments c INNER JOIN Posts p ON c.PostId = p.Id WHERE (p.Tags LIKE '%gson%' OR p.Tags LIKE '%google%') AND p.CreationDate >= '2023-01-01' AND ( c.Text LIKE '%completeness%' OR c.Text LIKE '%functionality%' OR c.Text LIKE '%accurate%' OR c.Text LIKE '%exact%' OR c.Text LIKE '%perfect%' OR c.Text LIKE '%precise%' OR c.Text LIKE '%proper%' OR c.Text LIKE '%exactness%' OR c.Text LIKE '%accuracy%' OR c.Text LIKE '%clarity%' OR c.Text LIKE '%correctness%' OR c.Text LIKE '%perfection%' OR c.Text LIKE '%nicety%' OR c.Text LIKE '%unnecessary steps%' OR c.Text LIKE '%fulness%' OR c.Text LIKE '%wholeness%' OR c.Text LIKE '%absoluteness%' OR c.Text LIKE '%reliable%' OR c.Text LIKE '%fault tolerant%' OR c.Text LIKE '%recoverability%' OR c.Text LIKE '%availability%' OR c.Text LIKE '%response time%' OR c.Text LIKE '%responsiveness%' OR c.Text LIKE '%throughput%' OR c.Text LIKE '%latency%' OR c.Text LIKE '%scalability%' OR c.Text LIKE '%reaction time%' OR c.Text LIKE '%latency period%' OR c.Text LIKE '%time interval%' OR c.Text LIKE '%interval%' OR c.Text LIKE '%processing time%' OR c.Text LIKE '%battery%' OR c.Text LIKE '%battery drainage%' OR c.Text LIKE '%memory usage%' OR c.Text LIKE '%CPU cycle%' OR c.Text LIKE '%storage%' OR c.Text LIKE '%capacity%' OR c.Text LIKE '%communication bandwidth%' OR c.Text LIKE '%user-friendly%' OR c.Text LIKE '%ease of use%' OR c.Text LIKE '%easy to understand%' OR c.Text LIKE '%accessible%' OR c.Text LIKE '%appealing%' OR c.Text LIKE '%aesthetical appealing%' OR c.Text LIKE '%guidelines%' OR c.Text LIKE '%instruction%' OR c.Text LIKE '%direction%' OR c.Text LIKE '%suggestion%' OR c.Text LIKE '%advice%' OR c.Text LIKE '%easy to remember steps%' OR c.Text LIKE '%controllability%' OR c.Text LIKE '%error protection%' OR c.Text LIKE '%ability%' OR c.Text LIKE '%secure%' OR c.Text LIKE '%correct%' OR c.Text LIKE '%use of color%' OR c.Text LIKE '%graphical design%' OR c.Text LIKE '%immunity%' OR c.Text LIKE '%safety%' OR c.Text LIKE '%integrity%' OR c.Text LIKE '%accountability%' OR c.Text LIKE '%authenticating%' OR c.Text LIKE '%similarity%' OR c.Text LIKE '%agreement%' OR c.Text LIKE '%fellow feeling%' OR c.Text LIKE '%screen fields%' OR c.Text LIKE '%tables%' OR c.Text LIKE '%transaction volumes%' OR c.Text LIKE '%report formats%' OR c.Text LIKE '%installed by an end user%' OR c.Text LIKE '%compactness%' OR c.Text LIKE '%convenience%' OR c.Text LIKE '%handiness%' OR c.Text LIKE '%lightness%' OR c.Text LIKE '%replaceability%' OR c.Text LIKE '%friendly%' OR c.Text LIKE '%wonderful%' OR c.Text LIKE '%reliable%' OR c.Text LIKE '%delightful%' OR c.Text LIKE '%first-class%' OR c.Text LIKE '%first-rate%' OR c.Text LIKE '%super%' OR c.Text LIKE '%fantastic%' OR c.Text LIKE '%incredible%' OR c.Text LIKE '%heavenly%' OR c.Text LIKE '%fabulous%' OR c.Text LIKE '%fab%' OR c.Text LIKE '%fantabulous%' OR c.Text LIKE '%awesome%' OR c.Text LIKE '%mind-blowing%' OR c.Text LIKE '%sparkling%' OR c.Text LIKE '%brilliant%' OR c.Text LIKE '%capital%' OR c.Text LIKE '%champion%' OR c.Text LIKE '%extremely good%' OR c.Text LIKE '%contentment%' OR c.Text LIKE '%gratification%' OR c.Text LIKE '%fulfillment%' OR c.Text LIKE '%joy%' OR c.Text LIKE '%enjoyment%' OR c.Text LIKE '%functionality%' OR c.Text LIKE '%fitness%' OR c.Text LIKE '%adequacy%' OR c.Text LIKE '%neatness%' OR c.Text LIKE '%convenience%' OR c.Text LIKE '%utility%' OR c.Text LIKE '%use%' OR c.Text LIKE '%value%' OR c.Text LIKE '%worth%' OR c.Text LIKE '%merit%' OR c.Text LIKE '%success%' OR c.Text LIKE '%benefits%' OR c.Text LIKE '%advantages%' OR c.Text LIKE '%helpfulness%' OR c.Text LIKE '%good avail%' OR c.Text LIKE '%help%' OR c.Text LIKE '%assistance%' OR c.Text LIKE '%confident%' OR c.Text LIKE '%believe%' OR c.Text LIKE '%faith%' OR c.Text LIKE '%safe%' OR c.Text LIKE '%assurance%' OR c.Text LIKE '%reliance%' OR c.Text LIKE '%safekeeping%' OR c.Text LIKE '%protection%' OR c.Text LIKE '%care%' OR c.Text LIKE '%guardianship%' OR c.Text LIKE '%fulfillment%' OR c.Text LIKE '%relief%' OR c.Text LIKE '%trust%' OR c.Text LIKE '%secure%' OR c.Text LIKE '%quality%' OR c.Text LIKE '%waste%' OR c.Text LIKE '%miss%' OR c.Text LIKE '%problem%' OR c.Text LIKE '%wrong%' OR c.Text LIKE '%accuracy%' OR c.Text LIKE '%completeness%' OR c.Text LIKE '%precision%' OR c.Text LIKE '%exactness%' OR c.Text LIKE '%validity%' OR c.Text LIKE '%authority%' OR c.Text LIKE '%reliability%' OR c.Text LIKE '%perfection%' OR c.Text LIKE '%faithfulness%' OR c.Text LIKE '%closeness%' OR c.Text LIKE '%truth%' OR c.Text LIKE '%truthfulness%' OR c.Text LIKE '%authenticity%' OR c.Text LIKE '%realism%' OR c.Text LIKE '%fairness%' OR c.Text LIKE '%rigour%' OR c.Text LIKE '%defense%' OR c.Text LIKE '%shielding%' OR c.Text LIKE '%shelter%' OR c.Text LIKE '%preservation%' OR c.Text LIKE '%conservation%' OR c.Text LIKE '%safe keeping%' OR c.Text LIKE '%safeguard%' OR c.Text LIKE '%safety%' OR c.Text LIKE '%support%' OR c.Text LIKE '%providence%' OR c.Text LIKE '%dependability%' OR c.Text LIKE '%slow%' OR c.Text LIKE '%limit%' OR c.Text LIKE '%fast%' OR c.Text LIKE '%lock%' OR c.Text LIKE '%unhurried%' OR c.Text LIKE '%leisurely%' OR c.Text LIKE '%moderate%' OR c.Text LIKE '%deliberate%' OR c.Text LIKE '%steady%' OR c.Text LIKE '%slow moving%' OR c.Text LIKE '%time to complete a task%' ) ORDER BY c.CreationDate DESC;