请描述您的问题地址:https://cloud.tencent.com/act/first_purchase?utm_source=portal&utm_medium=recommend&utm_campaign=first_purchase&utm_term=0226Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36
我有一个MySQL数据库,其中包含表示可能的拼车路线的表。这三个相关的表是一个拼车表(基数~200万)、一个carpool_stop表(基数~1100万)和一个trip表(基数~300K)。以下是示例:拼车:| carpool_id | completed ||我们的目标是获得所有满足这些条件的拼车:
at least one trip has a pickup_date later than a specifi