Question: using mysql write a query Show the total quantity included on all invoices where the total quantity is greater than or equal to 200. Trying
using mysql write a query Show the total quantity included on all invoices where the total quantity is greater than or equal to 200. Trying to get the quantity for all items on a given record, the invoice appears multiple times on the invoice_item table.

CUSTOMER customer id INTEGER first name VARCHAR last name VARCHAR street VARCHAR city VARCHAR state CHAR zipcode CHAR phone VARCHAR email VARCHAFR COMPLAINT EMPLOYEE complaint id INTEGEFR date DATE details BLOB customer id INTEGER tem_id INTEGER ITEM employee id INTEGER first name VARCHAR last name VARCHAR hire_date DATE street VARCHAR city VARCHAR state CHAR zipcode CHAR manager id INTEGER item_description VARCHAR INVOICE ITEM invoice id INTEGER item id INTEGE quantity INTEGER INVOICE invoice_id I date in DATE date out DATE customer_id INTEGER employee_id INTEGER
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
