Complete below SQL Project 1. List the number, Name, Balance for all customers EXCEPT/EXCLUDING Customer number, 148,
Question:
Complete below SQL Project
1. List the number, Name, Balance for all customers EXCEPT/EXCLUDING Customer number, 148, 462, 725 and 842
2. List the number, name, and available credit for all customers with credit limits that is lower than their
balances.
3. List the number, Name, and Balance for all customers with Customer number, 148, 462, 725 or 842
4. List the order number for each order that contains an order line for a part not located in warehouse 2
5. List the number, name, and credit limit of each customer whose credit limit is more than $8,000 together with the number, last name of the sales rep who represented the customer. Order the records by customer name.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill