Below is the description of the table LOCATIONS Name Null? Type -------------- -------- ------------ LOCATION_ID NOT NULL
Fantastic news! We've Found the answer you've been seeking!
Question:
Below is the description of the table LOCATIONS
Name Null? Type -------------- -------- ------------ LOCATION_ID NOT NULL NUMBER(4) STREET_ADDRESS VARCHAR2(40) POSTAL_CODE VARCHAR2(12) CITY NOT NULL VARCHAR2(30) STATE_PROVINCE VARCHAR2(25) COUNTRY_ID CHAR(2)
Wite a SELECT statement that returns any location whose country_id is not US, assuming that each record has some value for COUNTRY_ID.
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: