SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles...

SALESREP<br>SalesRepNo<br>654<br>734<br>345<br>434<br>RepName<br>Jones<br>Smith<br>Chen<br>Johnson<br>HireDate<br>01/02/2005<br>02/03/2007<br>01/25/2004<br>11/23/2004<br>CUSTOMER<br>CustNo<br>9870<br>8590<br>7840<br>4870<br>CustName<br>Winston<br>Gonzales<br>Harris<br>Miles<br>Balance<br>500<br>350<br>800<br>100<br>SalesRepNo<br>345<br>434<br>654<br>345<br>

Extracted text: SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 800 100 SalesRepNo 345 434 654 345

a) Write the standard SQL query to retrieve all information about the customer whose customer number is 8590<br>b) Write the standard SQL query to retrieve the Name and PhoneNumber of customers with a balance greater than<br>50<br>

Extracted text: a) Write the standard SQL query to retrieve all information about the customer whose customer number is 8590 b) Write the standard SQL query to retrieve the Name and PhoneNumber of customers with a balance greater than 50

Jun 10, 2022

SOLUTION.PDF

SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment