user
Given the following table, write a query to find the total revenue from items of category A.

Table:
Item         | Revenue | Category
------------ | --------|----------
Item 1       |  200    | A
Item 2       |  250    | B
Item 3       |  300    | A


assistant
SELECT SUM(r.Revenue) FROM table r WHERE r.Category = 'A';