MYSQL Two questions

AP SCHEMA

6. Write a SELECT state account_number SELECT statement that returns these three columns The account_number column from the General_Ledger_Accounts table The account_description column from the General_Ledger_Accounts table The invoice_id column from the Invoice_Line_Items table account_description invoice_id one row for each account number that has never been used. This hould return 54 rows. Hint: Use an outer join and only return rows where the invoice_id column contains a null value. Remove the invoice_id column from the SELECT clause. Sort the final result set by the account_number column. Use the UNION operator to generate a result set consisting of two columns from the Vendors table: vendor_name and vendor_state. If the vendor is in California, the vendor_state value should be "CA": otherwise, the vendor state value should be "Outside CA." Sort the final result set by vendor_name. 7 6. Write a SELECT state account_number SELECT statement that returns these three columns The account_number column from the General_Ledger_Accounts table The account_description column from the General_Ledger_Accounts table The invoice_id column from the Invoice_Line_Items table account_description invoice_id one row for each account number that has never been used. This hould return 54 rows. Hint: Use an outer join and only return rows where the invoice_id column contains a null value. Remove the invoice_id column from the SELECT clause. Sort the final result set by the account_number column. Use the UNION operator to generate a result set consisting of two columns from the Vendors table: vendor_name and vendor_state. If the vendor is in California, the vendor_state value should be "CA": otherwise, the vendor state value should be "Outside CA." Sort the final result set by vendor_name. 7