我有这样的疑问: from RCV_TRANSACTIONS ac.oe_order_line_id) cc on (a.shipment_line_id=cc.shipment_line_id and a.shipment_line_id=7085740) and a.shipment_line_id=7085740
account_id bigint, insert_timestamp timestamp with time zone DEFAULT now()我有以下SQL查询select count(*) from like_log where insert_timestamp >= (NOW() - INTERVAL '30 hours' ) AND account_id= 1105399
如何构造执行以下操作的SQL查询?首先,它将计数上面查