Here is my query:
- SELECT departments.department_name AS "Department name", locations.STREET_ADDRESS AS "Mailing address", locations.city, locations.state_province, locations.postal_code
-
FROM departments, locations
-
WHERE departments.location_id = locations.location_id
-
AND locations.country_id = 'US'
-
ORDER BY department_name;
and here is what the output is like:
- Department name Mailing address
-
------------------------------ ----------------------------------------
-
CITY STATE_PROVINCE POSTAL_CODE
-
------------------------------ ------------------------- ------------
-
Administration 2004 Charade Rd
-
Seattle Washington 98199
-
IT 2014 Jabberwocky Rd
-
Southlake Texas 26192
-
-
my query needs to list department names and mailing addresses of the departments located in the U.S. My current query accomplishes the result fine but the formatting is wrong because I need it to look like this (it's an sql excercise, I'm a newbie):
- Department Name Mailing Address
-
---------------------- -----------------------------------------------------
-
Administration 2004 Charade Rd, Seattle, Washington 98199
-
IT 2014 Jabberwocky Rd, Southlake, Texas 26192
-
How can I do this?
Thanks for your time.
PS: it doesn't matter if the displayed data is folded because of the number of lines allowed.
