> For the complete documentation index, see [llms.txt](https://anton-veselskyi.gitbook.io/codding-problems-solutions/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://anton-veselskyi.gitbook.io/codding-problems-solutions/codewars/7-kyu/grocery-store-inventory.md).

# GROCERY STORE: Inventory

## [GROCERY STORE: Inventory](https://www.codewars.com/kata/5a8eb3fb57c562110f0000a1)

You are the owner of the Grocery Store. All your products are in the database, that you have created after CodeWars SQL excercises!:)

Today you are going to CompanyA warehouse

You need to check what products are running out of stock, to know which you need buy in a CompanyA warehouse.

Use SELECT to show id, name, stock from products which are only 2 or less item in the stock and are from CompanyA.

Order the results by product id

### products table schema

* id
* name
* price
* stock
* producent

### results table schema

* id
* name
* stock

## Solutions

#### 🗃️ Sql

```sql
select id, name, stock
from products
where stock < 3 and producent like 'CompanyA'
order by id;
```