将下面sqlr如何写嵌套?SELECT c.ticketno FROM my_otaorder a INNER JOIN ( SELECT ticketno, min( checkedtime ) AS checktime FROM my_checkin GROUP BY ticketno ) c ON a.codename = c.ticketno WHERE c.checktime BETWEEN '2019-06-11 00:00:00' AND '2019-06-11 23:59:00' AND c.TicketNo like'WQ%'