ANY、SOME

• ALL 比對subquery 所有的回傳值，只要任一回傳值符合就成立，如果subquery沒有回傳值，也是不成立(SQLite 不支援)

select car.cid,car.model ,car.price,car.price*sale.num from car,sale where car.cid=sale.cid

and car.price*sale.num >

some

(

select car.price*sale.num from car,sale where car.cid=sale.cid and car.model like '5%'

)