Please help :

1. Find all vendors who supplied less than two products. Provide SQL code and the screenshot of the results. ( this needs to be in oracle sql

tables have been attached as screeshot:

here is my code:

select table_product.prod_id, count(table_vendor.vend_name) as vendor_count

from table_product

inner join table_vendor

on table_product.prod_vendor = table_vendor.vend_ID

where count(vend_name PROD IDI PROD NAME PROD PRICE! PROD PROD DATE PROD VENDOR 1101 Table 1102 Chair 1103 Armchair 1104 | Nightstand 1105 Bed 1106 Dresser 1107 Daybed 100 80 90 110 200 150 190 1-Jan-18 3-Mar-18 6-May-18 4-Apr-18 3-Mar-18 5-May-18 10-Feb-18 2 2 2 Table Vendor: VEND IDI VEND NAME VEND_ST 1 Green Way IncGA 2 Forrest LLC 3 AmeriMart NC NC