SQL Statement

Greetings,

I am looking for 2 SQL statements if you please:

The first would make items available on web by category, one category at a time.

The second would make items available on web by manufacturer, one manufacturer at a time.

Thanks in advance.