You are the database administrator for the XYZ Furniture Company. Management is reviewing its Customer Management System (CMS). Within the system, there are two tables: clients and contacts. Clients is linked to Contacts by ContactID. Clients has additional information available in it that may not be available in Contacts. You know that all Clients are Contacts but not all Contacts are Clients. Clients stores the structure of the tables is below.
ContactsClients ContactID* ClientID ContactName ContactID ContactAddress Billable (T/F) Email PastDueAmount (float) Phone ContactType
You have been tasked with finding the names, addresses, and emails for billable clients with a past due bill. Create the SQL to retrieve the data from the tables. Identify at least one other query opportunity that you would be able to create a useful report for, from the two tables.
Sample Solution
