53. Customer table SPNUM HQCITY CUSTNUM CUSTNAME 137 New York 0121 Company A 196 Chicago 0630 Company B 137 Los Angeles 0033 Company C 137 Los Angeles 1047 Company D 1525 Company E 361 Atlanta 1700...

53. Which SELECT statement retrieves the customer name for those that have a salesperson number of 137? A: SELECT CUSTNAME FROM CUSTOMER WHERE SPNUM 137; B: SELECT* FROM CUSTNAME WHERE SPNUM=137; C: SELECT CUSTOMER FROM CUSTNAME WHERE SPNUM=137; D:SELECT* FROM CUSTOMER WHERE SPNUM=13753.<br>Customer table<br>SPNUM<br>HQCITY<br>CUSTNUM<br>CUSTNAME<br>137<br>New York<br>0121<br>Company A<br>196<br>Chicago<br>0630<br>Company B<br>137<br>Los Angeles<br>0033<br>Company C<br>137<br>Los Angeles<br>1047<br>Company D<br>1525<br>Company E<br>361<br>Atlanta<br>1700<br>Company F<br>361<br>Washington<br>1826<br>Company G<br>137<br>New York<br>2196<br>Company H<br>204<br>New York<br>2267<br>Company I<br>196<br>New York<br>

Extracted text: 53. Customer table SPNUM HQCITY CUSTNUM CUSTNAME 137 New York 0121 Company A 196 Chicago 0630 Company B 137 Los Angeles 0033 Company C 137 Los Angeles 1047 Company D 1525 Company E 361 Atlanta 1700 Company F 361 Washington 1826 Company G 137 New York 2196 Company H 204 New York 2267 Company I 196 New York

Jun 05, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here