for my database exercise:

using SQL

Now lets create a view:

Create a view that holds information (name and phone numbet) for bad payers i.e. the payers that have a payment date that is later (larger) than the invoice due date or have a payment date that is null. Include also the invoice_id.

Use the view: write a select statement to find the bad payers whose name starts with B.