SQL query with SELECT COUNT() in SELECT - subquery example

Would you please provide working example how to use SQL SELECT with COUNT() in SELECT query ?

Hi,

The subquery with "SELECT in SELECT" should look for example like this:

SELECT item_name FROM items AS i WHERE i.available_pcs = (SELECT COUNT(*) FROM reserved_items AS r WHERE i.item_id = r.item_id );