我尝试了这两个查询,要么没有显示任何内容,要么一切都混淆了。我不知道这里需要什么样的查询
SELECT * FROM products WHERE price>(SELECT AVG(price) FROM products WHERE category =(SELECT id FROM categories WHERE id=1))
SELECT * FROM products WHERE id=(SELECT id FROM categories WHERE id=1 and price=(Select price FROM products WHERE price>(SELECT AVG(price) FROM products)))