用mysql，求大神帮忙查询出图中的sql

Question

PRODUCER   表

PRODUCT   表

Answer 1

SELECT
	*,
	( CASE WHEN a.cost >= 3000 THEN 1 WHEN a.cost <= 500 THEN 0 END ) biaoji 
FROM
	product a
	LEFT JOIN producter b ON a.producterid = b.producterid 
WHERE
	a.producterid IN ( SELECT producterid FROM producter WHERE city IN ( 'Shanghai', 'NewYork ' ) ) 
	AND ( a.cost >= 3000 OR a.cost <= 500 )

注意检查一下我的字段有没有拼写对，图片太糊了。*号换成你要查询的字段