该连锁总部对应的该品种在上年无购进记录，本年有购进记录的sql怎么写

我可以回答这个问题。您可以使用以下 SQL 语句来查询该连锁总部对应的该品种在上年无购进记录，本年有购进记录的数据：

SELECT *
FROM purchase_records
WHERE chain_headquarters = '连锁总部名称'
AND product_type = '品种名称'
AND purchase_year = '本年'
AND purchase_quantity > 0
AND NOT EXISTS (
SELECT *
FROM purchase_records
WHERE chain_headquarters = '连锁总部名称'
AND product_type = '品种名称'
AND purchase_year = '上年'
AND purchase_quantity > 0
)