Homework

[Rahsaan Tyler]

Hello everyone. I am currently in a MySQL class. I am having a hard time following along. It is making it hard to solve the questions I have. I am a visual learner and I just need resources (videos) I could watch besides reading this textbook. Below is the question I have to answer. Below that is where I cam currently stuck at.

Write a SELECT statement that returns these three columns:

account_number - The account_number column from the General_Ledger_Accounts table

account_description - The account_description column from the General_Ledger_Accounts table

invoice_id - The invoice_id column from the Invoice_Line_Items table

Return one row for each account number that has never been used. This should 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

SELECT account_number, account_description, invoice_id
FROM General_Ledger_Accounts
JOIN invoice_line_items
WHERE account_number
ORDER BY invoice_id