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 are linked to Contacts by ContactID. Clients have 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 store 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. You may add columns to either table if you would like. The new columns should be logical and make sense if you choose to add them.
You are the
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. You may add columns to either table if you would like. The new columns should be logical and make sense if you choose to add them.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
