Play Around Toys Inc. wants to adapt a new business strategy to increase revenue
ID: 3669174 • Letter: P
Question
Play Around Toys Inc. wants to adapt a new business strategy to increase revenue.
Tasks:
Perform a Join operation on the tables tbl Customers and tbl Orders.
Develop a simple query to generate a customer analysis report.
Submit a report describing what the database information reveals about customer behavior and the business strategies that could be pursued to increase revenue.
tbl Customers tbl Ord Join By Customer ID State Click to Add Address 1 Main Street Indianapolis IN 2 Main Street GreenwoodIN 3 Main Street Indianapolis IN 4 Main Street Carmel 5 Main Street Indianapolis IN 6 Main Street Indianapolis IN 7 Main Street Carmel 8 Main Street Indianapolis IN 9 Main Street Carmel 10 Main Street Indianapolis IN Customer ID Last Name First Name City Zip 1000 Finley 1001 Smith 1002 Thompson 1003 Scott 1004 Davidson 1005 Jones 1006 Davis 1007 Fole 1008 David 1009 Ruslh Jane Scott Dave Ken Mike Dana Gina Sue Rose Sara 46239 46140 46214 46032 46250 46278 46032 46227 46032 46268 IN IN INExplanation / Answer
1. SELECT CUSTOMER_ID, LAST_NAME, FIRST_NAMR FROM CUSTOMERS, ORDERS
WHERE CUSTOMERS.CUSTOMER_ID = ORDERS.CUSTOMER_ID;
2. SELECT CUSTOMER_ID, LAST_NAME, FIRST_NAME FROM CUSTOMERS;