Library

SQL at Wok Series Tickets

Input Data

Input: tickets

ticket_id opened_at days_open
T101 11 Oct, 10 AM 0
T102 10 Oct, 10 AM 1
T103 9 Oct, 10 AM 2
T104 7 Oct, 10 AM 4
T105 3 Oct, 10 AM 8

 

Code

SELECT ticket_id,
       TIMESTAMPDIFF(
           DAY,
           opened_at,
           '2026-09-26 10:00:00'
       ) AS days_open
FROM tickets;

Output
ticket_id days_open
T101 0
T102 1
T103 2
T104 4
T105 8