Question
Please help : Find all vendors who supplied less than two products. Provide SQL code and the screenshot of the results. ( this needs to
Please help :
- 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started