departments DEPARTMENT_ID MANAGER_ID LOCATION_ID DEPARTMENT_NAME 10 Administration 200 1700 20 Marketing 201 1800 50 Shipping 124 1500 60 IT 103 1400 80 Sales 149 2500 90 Executive 100 1700 110...


Use departments. Create a query to display all the data from that table as one column. Separate each data value by a \ and add the \ at the start and end of the output row. Display the results in descending order of location id, and alpha order of department name within location id. Name the column title THE DEPARTMENTS OUTPUT.
Ex: \20\Marketing\201\1800\














departments<br>DEPARTMENT_ID<br>MANAGER_ID<br>LOCATION_ID<br>DEPARTMENT_NAME<br>10 Administration<br>200<br>1700<br>20 Marketing<br>201<br>1800<br>50 Shipping<br>124<br>1500<br>60 IT<br>103<br>1400<br>80 Sales<br>149<br>2500<br>90 Executive<br>100<br>1700<br>110 Accounting<br>190 Contracting<br>205<br>1700<br>1700<br>

Extracted text: departments DEPARTMENT_ID MANAGER_ID LOCATION_ID DEPARTMENT_NAME 10 Administration 200 1700 20 Marketing 201 1800 50 Shipping 124 1500 60 IT 103 1400 80 Sales 149 2500 90 Executive 100 1700 110 Accounting 190 Contracting 205 1700 1700
locations<br>LOCATION_ID<br>STREET_ADDRESS<br>POSTAL_CODE<br>CITY<br>STATE_PROVINCE<br>COUNTRY ID<br>1400 2014 Jabberwocky Rd<br>26192 Southlake<br>Техas<br>US<br>1500 2011 Interiors Blvd<br>99236 South San Francisco<br>California<br>US<br>1700 2004 Charade Rd<br>98199 Seattle<br>Washington<br>US<br>1800 460 Bloor St. W.<br>ON M5S 1X8<br>Toronto<br>Ontario<br>CA<br>2500 Magdalen Centre, The Oxford Science (OX9 9ZB<br>Oxford<br>Oxford<br>UK<br>

Extracted text: locations LOCATION_ID STREET_ADDRESS POSTAL_CODE CITY STATE_PROVINCE COUNTRY ID 1400 2014 Jabberwocky Rd 26192 Southlake Техas US 1500 2011 Interiors Blvd 99236 South San Francisco California US 1700 2004 Charade Rd 98199 Seattle Washington US 1800 460 Bloor St. W. ON M5S 1X8 Toronto Ontario CA 2500 Magdalen Centre, The Oxford Science (OX9 9ZB Oxford Oxford UK

Jun 10, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?