3. Using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from the EMPLOYEE table into the EMP_1 table. Remember, your subquery should only retrieve the columns needed for the EMP_1 table and only the employees shown in the figure. Figure P8.2.The Contents of the EMP_1 TableEMP_NUM EMP_LNAME EMP_FNAME101102103EMP INITIALEMP HREDATE JOB_CODENewsJohn08-Nov-00 502SeniorDavidH.12-Jul-89 501EKKArboughJune01-Dec-96 500104105106107RamorasAnne15-Nov-87 501JohnsonAlice01-Feb-93 502SmithfieldWilliam22-Jun-04 500AlonzoMariaD.10-Oct-93 500108WashingtonRalph22-Aug-91 501109SmithLarry18-Jul-97 501

3. Using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from the EMPLOYEE table into the EMP_1 table. Remember, your subquery should only retrieve the columns needed for the EMP_1 table and only the employees shown in the figure.

3. Using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from the EMPLOYEE table into the EMP_1 table. Remember, your subquery should only retrieve the columns needed for the EMP_1 table and only the employees shown in the figure.

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

Similar questions

Which function does the PRIMARY KEY clause perform in table creation? It ensures that’s non-NULL values can act as unique keys. It ensures that non-NULL values can as candidate keys. It ensures that each value in row is unique. It ensures that each value in the column is unique
Create a View to show the city name of any location that has a department. Only show the city name once in the results. You must use a non-correlated subquery.Call this view: Department_LocationsInclude a second query to display from the View after it is created. Refer to the attached for the table.
Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.
The BLOOD_ADMIN_INFO are ORDER ID and LINE. The MAR_ADMIN_INFO MAR_BLOOD_INFO_LN table has one row per blood unit associated with an order. Its primary key columns table has one row per medication administration. The columns ORDER_MED_ID and form the foreign key to the BLOOD_ADMIN_INFO table. Use the followin*query to answer the question below it- SELECT mar.ORDER_MED_ID, mar.SCHEDULED_TIME, mar.TAKEN TIME, bld.BLOOD_ADMIN_TYPE FROM MAR_ADMIN_INFO as mar INNER JOIN BLOOD_ADMIN_INFO as bld What join condition is appropriate in ? AS [Blood Type] Select on of the following: A. mar.ORDER_MED_ID = bld.ORDER_ID B. mar.MAR_BLOOD_INFO_LN = bld.LINE C. mar.ORDER_MED_ID = bld.ORDER_ID AND mar.MAR_BLOOD_INFO_LN = bld.LINE D. It is not possible to join these tables
Write the following as MySQL query: Find the employee ID, first and last name, and salary for each employee whose salary ismore than $20,000 or who works in the shipping department. Use the UNION set operator. List the country ID, country name, city, and state/province. Be sure all country names areincluded in the result, regardless of whether there is no matching city and state/province. You have to use an outer join.
PLZ help with the following using ORACLE command sql Use subqueries CREATE TABLE MEMBERSHIP ( MEM_NUM CHAR(3) CONSTRAINT MEMBER_MEM_NUM_PK PRIMARY KEY, MEM_FNAME VARCHAR(30) NOT NULL, MEM_LNAME VARCHAR(30) NOT NULL, MEM_STREET VARCHAR(15), MEM_CITY VARCHAR(10), MEM_STATE CHAR(2), MEM_ZIP CHAR(5), MEM_BALANCE NUMBER (2)); CREATE TABLE RENTAL ( RENT_NUM CHAR(4) CONSTRAINT RENTAL_RENT_NUM_PK PRIMARY KEY, RENT_DATE DATE, MEM_NUM CHAR(3), CONSTRAINT RENTAL_MEM_NUM_FK FOREIGN KEY (MEM_NUM) REFERENCES MEMBERSHIP); CREATE TABLE PRICE (PRICE_CODE CHAR(1) CONSTRAINT PRICE_PRICE_CODE_PK PRIMARY KEY, PRICE_DESC VARCHAR(20), PRICE_RENTFEE NUMBER (3,1), PRICE_DAILYATFEE NUMBER(3,1)); CREATE TABLE MOVIE (MOVIE_NUM CHAR(4) CONSTRAINT MOVIE_MOVIE_NUM_PK PRIMARY KEY, MOVIE_NAME VARCHAR(30) NOT NULL, MOVIE_YEAR CHAR(4), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR(15), PRICE_CODE CHAR(1), CONSTRAINT MOVIE_PRICE_CODE_FK FOREIGN KEY (PRICE_CODE) REFERENCES PRICE); CREATE TABLE VIDEO…
For this problem create a (temporary) table called instructor_course_nums. Write a procedure that accepts an instructor ID as input. The procedure calculates the total number of course sections taught by that instructor, and adds a tuple to the temporary table consisting of the instructors ID number, name, and total courses taught - call these attributes: ID, name, and tot_courses. If the instructor already has an entry in the table,then the procedure makes sure the total number of courses taught in the temporary table is up-to-date. You must name your procedure: Written in PostgreSQL
The given SQL creates a Song table and inserts some songs. The first SELECT statement selects songs released after 1992. The second SELECT statement selects the release year for song with ID 800. Create a third query that combines the two existing queries. The first SELECT should be the outer query, and the second SELECT should be the subquery. The ORDER BY clause should appear after the subquery. Run your solution and verify the new query returns a result table with five rows, all with release years after 1992. CREATE TABLE Song (ID INT,Title VARCHAR(60),Artist VARCHAR(60),ReleaseYear INT,Genre VARCHAR(20),PRIMARY KEY (ID)); INSERT INTO Song VALUES(100, 'Hey Jude', 'Beatles', 1968, 'pop rock'),(200, 'You Belong With Me', 'Taylor Swift', 2008, 'country pop'),(300, 'You\'re Still the One', 'Shania Twain', 1998, 'country pop'),(400, 'Need You Now', 'Lady Antebellum', 2011, 'country pop'),(500, 'You\'ve Lost That Lovin\' Feeling', 'The Righteous Brothers', 1964, 'R&B'),(600, 'That\'s…
Rewrite the following query using a join statement (no subqueries). (0.5) SELECT productid, productname, productprice FROM product WHERE productid IN (SELECT productid FROM soldvia GROUP BY productid HAVING SUM(noofitems) > 3);
a. Write a query to get all unique first names that start with the letter W from the student table. Output the names in all upper case. Sort the results in ascending order. Write a query to get the first 3 characters of all last names that start with an T from the student table and sort them in descending order.
Insert at least three rows into your EMPLOYEE_xx table. Use the next value of the sequence you created , EMPL_SEQUENCE_xx as the value for the employee ID for every row inserted. You may choose values for the other columns Test your constraint on the rate column by trying to update a row in the EMPLOYEE_xx table with the value of 6 used for the Pay Rate (you choose the row). Drop your EMPLOYEE_xx table and make sure it HAS been purged from the recyclebin
From vendors table, write a query to retrieve records as follows: On the first column, add vendorcontact first name, a space, and vendor contact last name. Name the first column “Vendor ContactFull Name”. On the second column, retrieve the total number of characters of the “Vendor ContactFull Name” column. Do NOT count the space in between first name and last name. Name thesecond column “Full Name Length”.The two columns should look like this:Vendor Contact Full Name Full Name LengthJinsoo Yeo 9Hint1: CONCAT and CHAR_LENGTH functions might be useful!Hint2: the number of characters for Francesco Alberto is 16.