SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
SELECT COUNT(t.ticket_no) AS num_tickets_without_boarding_passes FROM tickets t LEFT JOIN boarding_passes b ON t.ticket_no = b.ticket_no WHERE b.boarding_passes is null
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear