MYSQL Database
1) Write a summery query that calculates the number ofvendors based on each state and city within the samestate.
vendors vendor_id INT vendor name VARCHAR(50) terms terms id INT terms-description VARCHAR(50) 「-·-H ◇ vendor-address! VARCHAR(50) ◆ terms-due-days INT Indexes vendor-address2 VARCHAR(50) vendor_city VARCHAR(50) ◆ vendor-state CHAR(2) vendor_zip_code VARCHAR(20) ◇ vendor-phone VARCHAR(50) ◇ vendor-contact-last-name VARCHAR(50)-t–7 ◇ vendor-contact-first-name VARCHAR(50) コinvoices invoiceid INT ◆ vendor id INT default, terms-id INT default-account-number lNT invoice-number VARCHAR(50) invoicedate DATE – Indexes ◆ invoice, total DECIMAL(9,2) payment total
OR
OR