0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for ebook publishers and readers

-- Query 4: Booking Problems and Customer Pain Points
-- Helps with Questions 3 & 5 about AI/ML opportunities and trust
SELECT TOP 100
    'https://travel.stackexchange.com/questions/' + CONVERT(VARCHAR, Posts.Id) as url,
    Title,
    ViewCount,
    Score,
    CreationDate
FROM Posts 
WHERE Posts.PostTypeId = 1
    AND (
        Title LIKE '%cancel%'
        OR Title LIKE '%refund%'
        OR Title LIKE '%change%'
        OR Title LIKE '%problem%'
        OR Title LIKE '%booking issue%'
    )
    AND ViewCount > 100  -- Focus on common issues
ORDER BY ViewCount DESC;

fork query

edited dec 7

created dec 7 anonymous