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

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
Get step-by-step solutions from verified subject matter experts
