Question: Write a query that will show vendor name, default account number, and account description. Only include account descriptions that contain an x or a q.

Write a query that will show vendor name, default account number, and account description. Only include account descriptions that contain an x or a q. Note - do not include invoices and invoice_line_items table in query

Write a query that will show vendor name, default account number, and

terms terms_id INT - terms_description VARCHAR(50) terms_due_days INT Indexes vendors vendor_id INT vendor_name VARCHAR(50) vendor_address1 VARCHAR(50) 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) -- vendor_contact_first_name VARCHAR(50) default_terms_id INT default_account_number INT Indexes invoices invoice_id INT vendor_id INT invoice_number VARCHAR(50) invoice_date DATE invoice_total DECIMAL (9,2) payment_total DECIMAL(9,2) credit_total DECIMAL(9,2) terms_id INT invoice_due_date DATE payment_date DATE Indexes general_ledger_accounts account_number INT account_description VARCHAR(50) Indexes 1 invoice_line_items invoice_id INT invoice_sequence INT +account_number INT line_item_amount DECIMAL (9,2) line_item_description VARCHAR(100) Indexes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!