我有一个SQL查询:FROM devices d SELECT device_category, COUNT(*) AS cnt FROM devices GROUP BY device_categoryORDER BY我的尝试是:
sub_dquery = db.session.query(Devices.device_category, func.
SELECT devices.make, TotalServices=Count(services.id),
AssignedOwner=(SELECT assignments.studentID FROM devices INNER JOIN assignments ON devices.assetID=assignments.assetIDWHERE assignments.assetID=<VALUE OF ASSET ID