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\ departmentsDEPARTMENT_IDMANAGER_IDLOCATION_IDDEPARTMENT_NAME10 Administration200170020 Marketing201180050 Shipping124150060 IT103140080 Sales149250090 Executive1001700110 Accounting190 Contracting20517001700 locationsLOCATION_IDSTREET_ADDRESSPOSTAL_CODECITYSTATE_PROVINCECOUNTRY ID1400 2014 Jabberwocky Rd26192 SouthlakeТехasUS1500 2011 Interiors Blvd99236 South San FranciscoCaliforniaUS1700 2004 Charade Rd98199 SeattleWashingtonUS1800 460 Bloor St. W.ON M5S 1X8TorontoOntarioCA2500 Magdalen Centre, The Oxford Science (OX9 9ZBOxfordOxfordUK

Here are the PL/SQL commands you need. CREATE TABLE DEPARTMENTS ( DEPT_ID NUMBER(4) PRIMARY KEY,…

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

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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Create a query for selecting all data from employees table by concatenating first name and last name…

A: SELECT first_name+ ','+last_name+'' AS Full_Name , Email + ', ' + Email_address + ' ' AS…

Q: Create table sales ( sales_no number (4), sales_date date ); Insert into sales values…

A: --creating tablecreate table orders(order_number number primary key,order_date date,ship_city…

Q: Using the code below, write a query to display the movie title, movie year, and movie genre for all…

A: Algorithm:Execute the CREATE TABLE SQL command to create a table named MOVIE with columns movie_id,…

Q: Question #8. From invoices table, write a query to retrieve everything (all columns), plus, add an…

A: The query is given in the below step

Q: Write a query to display the author ID, first and last name for all authors who have never written a…

A: The below query will return the author ID, first name, and last name for all authors who have never…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Write a query to display the author ID, first name, last name, and year of birth for all authors.…

A: A database may be defined in one of these ways it's an organized series of established facts or…

Q: Question 1: Modify the select statement in this section to display the hire_date column in the…

A: SQL which refers to the domain specific that are used for the language and in the programming and…

Q: using the code belowe write a query to display the movie genre and average price rental fee for…

A: In the database analysis, understanding the distribution of movie costs across genres is a crucial…

Q: Using the software.subscription table, pull all columns for subscriptions that have been cancelled.…

A: For the given database, if the user wants to select all the columns by giving the condition that the…

Q: using the code write a query to display the movie number, movie title, and price code for all movies…

A: Algorithm:Define a table named PRICE with columns PRICE_CODE, PRICE_DESCRIPTION, PRICE_RENTFEE, and…

Q: using the code below write a query to display the movie title, movie year, and movie genre for all…

A: Algorithm: Retrieve and Sort Movie Information by Genre and Year1. Create a MOVIE table with…

Q: using the code write a query to display the movie number, movie title, and movie year for all movies…

A: Algorithm:Create a table named MOVIE with columns for movie information (number, title, year, cost,…

Q: Create a query to display all donors that live in City1, City2 or City3. Use the IN clause.

A: here In question ask query about IN clause Query: display all donors that live in City1, City2 or…

Q: Q1) Please write. a query statement from emp table to display deptno 10â€™s empno, ename, sal, and a…

A: --> As new_sale is increased 15% that means it increases by 115 out of 100% which is 115/100 =…

Q: Create a Query with all products information whose price is >20.

A: Lets see the solution.

Q: Create a query based on tblReservations that displays the guests that have reservations for all…

A: Structured Query Language, abbreviated as SQL, which usually refers to the one it is a…

Q: List every table that contains a column named OWNER_NUM. The output table should display one column…

A: The first ever freely programmable computer came into play in 1936, however after that International…

Q: 3. Write a query that retrieves the following results (note the column names and order of results):

A: The required result needs to fetch below columns : Pub_id -> from publisher table Publisher's…

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: Create a query for displaying maximum salary earned by employee working in IT department. Provide…

A: Lets see the solution.

Q: Write a query to display the customer code, first name, last name of all customers who made more…

A: Select: The SELECT statement is used to select data from a database. SELECT Syntax SELECT…

Q: 5. For each order, list the order number, quoted price and the item description, when the category…

A: 5. To get the required results, we need to use ORDERS, OPRDERLINE, ITEM tables Query: SELECT…

Q: Query 2: Write a query to display every member in Ohio who made a payment greater than or equal to…

A: Select (First name, Lastname) from Payment where State = "Ohio" AND Amount>=300; The above…

Q: using the code below write a query to display the movie title, movie genre, price description, and…

A: Select Columns: Choose the columns to be displayed: MOVIE_TITLE, MOVIE_GENRE, PRICE_DESCRIPTION, and…

Q: using the code write a query to display the movie number, movie title, movie cost, and movie genre…

A: 1. Create a table named MOVIE: - Define columns: - MOVIE_NUM as INT (Primary Key) -…

Q: 2) Create a SELECT statement that returns the count, average, max and min of the invoices submitted…

A: SQL: SQL is defined as Standard Query Language it is mainly used for the manipulation of the…

Q: Question 4 Write a query to display the first name concatenated with the last name as Full Name, and…

A: This particular question belongs to Computer Science and Engineering. Computer Science is an…

Q: Write a query that will display all movies with a return date of March 1, 2018, March 5, 2018, March…

A: Sql query to display all the movies with a return date of March 1, 2018, March 5, 2018, March 15,…

Q: Create a Query with all products information whose price is >20.

A: Lets see the solution.

Q: 9. Create a query to show all the fields in EMPOLYEE and SPORTS table. Save the query as ES11 ' 10…

A: Answer 9: SELECT e.empno,e.empname,e.phone,e.place,e.doj…

Q: write a query where there is time difference between start time and end time in hours for example:…

A: The SQL query is given below with output screenshot

Q: Write a query to display the movie year, movie title, and movie cost sorted by movie year in…

A: 1. Create a new database (if not exists).2. Use the newly created database.3. Create RENTAL table…

Q: 1. Use Employees table a) To display First_Name, Salary and Department_id ofall the employees, whose…

A: 1. A) select First_name, Salary, Department_idfrom Employeeswhere Department_id IN(50,80)…

Q: Alter table supplierTransaction add column paymentDate as data type date, not null, default value of…

A: Query from table Purchase Order ALTER TABLE purchaseOrder RENAME COLUMN WHERE EXISTS (SELECT 1…

Q: - What will be the result of the query besed. on the followry criteria ? <columnncomes = All…

A: The functionality of ALL command in SQL is should compare each and every value in result and returns…

Q: Create a complex view that joining with three tables.

A: The given 3 tables are creating tables to store Employee, Job and Department details. The tables…

Q: Use the code below to write a query to display the movie title, movie year, and movie genre for all…

A: SQL (Structured Query Language) is a standard programming language for managing and manipulating…

Q: eference table 6-28. Include both SQL commands and results/answers in your answers. In the NONCAT…

A: SOLUTION - (1) Query - UPDATE NONCATSET PRICE = (PRICE * 1.05)WHERE CATEGORY='BRD'; This query is…

Question

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
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
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

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Problem 15, Need help please. Use a query to compute the total of all purchases, the number of purchases, and the average purchase amount made by each customer. Your output values must match those shown in Figure P7.15. Sort the results by customer code.
Write a query to display the book title, price and publisher name for all books.
ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear
d. write a query to retrieve the name of graduate student and student advisor name of all graduate student.
1.CREATE TABLE contacts ( last_name VARCHAR(30) NOT NULL, first_name VARCHAR(25) NOT NULL, birthday DATE, CONSTRAINT contacts_pk PRIMARY KEY (last_name, first_name) ); Use insert query and insert the values and display the table.
Question #10.Write a query to retrieve invoice_number, invoice_date, and “Balance Due” from the invoices table.Balance Due can be calculated by subtracting payment and credit from the original invoicedamount. Make sure to only select rows with positive “Balance Due” and sort the results basedon Balance Due. Refer to the sample result screen below.
using the code below write a query to display the minimum balance, maximum balance, and average balance for memberships that have a rental CREATE TABLE MEMBERSHIP ( MEM_NUM NUMBER(8,0) PRIMARY KEY, MEM_FNAME VARCHAR2(30) NOT NULL, MEM_LNAME VARCHAR2(30) NOT NULL, MEM_STREET VARCHAR2(120), MEM_CITY VARCHAR2(50), MEM_STATE CHAR(2), MEM_ZIP CHAR(5), MEM_BALANCE NUMBER(10,2) ); CREATE TABLE RENTAL ( RENT_NUM NUMBER(8,0) PRIMARY KEY, RENT_DATE DATE DEFAULT SYSDATE, MEM_NUM NUMBER(8,0) CONSTRAINT RENTAL_MEM_NUM_FK REFERENCES MEMBERSHIP ); INSERT INTO MEMBERSHIP VALUES (102, 'TAMI', 'DAWSON', '2632 TAKLI CIRCLE', 'NORENE', 'TN', '37136', 11); INSERT INTO MEMBERSHIP VALUES (103, 'CURT', 'KNIGHT', '4025 CORNELL COURT', 'FLATGAP', 'KY', '41219', 6); INSERT INTO MEMBERSHIP VALUES (104, 'JAMAL', 'MELENDEZ', '788 EAST 145TH AVENUE', 'QUEBECK', 'TN', '38579', 0); INSERT INTO MEMBERSHIP VALUES (105, 'IVA',…
Given a small company database tables below. Create the database and tables for the company and answer all the questions below. LINE CUSTOMER VENDOR INV_NUMBER LINE_NUMBER P_CODE LINE_UNITS LINE_PRICE Cus CODE CUS_LNAME CUS_FNAME CUS_INITIAL cus AREACODE CUS_PHONE CUS_BALANCE V_CODE V_NAME V_CONTACT V_AREACODE V_PHONE V_STATE V_ORDER 1000 3 23100-HB 0.05 10010 Ramas Afred 015 844-2573 21225 Bryson, Ine. Smithson 015 223-3234 TN 1006 4 89-WRE-Q 256.00 10011 Dunne Leona 713 804-1238 21220 SuperLoo, Inc. Flushing 04 215-8006 FL N 1 13-Q2/P2 2 14.00 1007 10012 Smith Kathy 015 804-2205 345.88 21231 DSE Supply Singh 815 228-3246 TN 1007 254778-2T 4.00 10013 Olowski Paul 815 804-2100 530.75 21344 Gomez Bros. Ortega 815 889-2546 KY N 1008 1 PVC23DRT 5.87 10014 Orlando Myron le15 222-1872 22507 Dome Supply Smith 01 e78-1419 GA IN 1008 2 WR3/TT3 3 110.05 10015 OBrian Amy 713 442-3381 23110 Randsets Ltd. Anderson 001 078-3008 GA 1008 3 23100-HB 0.05 10010 Brown James 015 297-1228 221.19 24004…