I don't know what I'm doing wrong. I cannot get past this problemUsing the EMP_2 table, write a single SQL command to change the EMP_PCT value to 10.00 for all employees who do not currently have a value for EMP_PCT. Feedback ®Some expected rows were missing (shown in red below).Some unexpected rows were returned.Test Query OSELECT * FROM EMP_2 WHERE EMP_PCT = 10Expected ResultsEMP_NUM EMP_LNAME EMP_FNAME EMP_INITIAL EMP_HIREDATE JOB_CODE EMP_P(102SeniorDavidH1989-07-1250110.00104RamorasAnneK1987-11-1550110.00108Washington RalphВ1991-08-2250110.00109SmithLarryW1997-07-1850110.00Actual Results ®EMP_NUM EMP_LNAME EMP_FNAME EMP_INITIAL EMP_HIREDATE JOB_CODE EMP_P(103ArboughJuneE1996-12-0150010.00104RamorasAnneK1987-11-1550110.00108WashingtonRalph1991-08-2250110.00B.

There are more different types of commands, and their statements are available in SQL (Structured…

Answered: Using the EMP_2 table, write a single…

Using the EMP_2 table, write a single SQL command to change the EMP_PCT value to 10.00 for all employees who do not currently have a value for EMP_PCT.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter6: Additional Database Objects

Section: Chapter Questions

Problem 1HOA

See similar textbooks

Similar questions

Hi, I have the query below and I get it to run, but it is missing something how to answer the problem. My joins appear to be incorrect, I am using ID_number and S_ID. so I am completely lost there. CREATE OR REPLACE PROCEDURE Moreno_03_insCourseNumsProc(INOUT i_ID VARCHAR(5))LANGUAGE PLPGSQLAS$$DECLAREname VARCHAR(35);tot_courses INTEGER; -- Created this variable to hold the total course taught by the instructor l_exists_count INTEGER := 0; -- This is to identify the existence of the records the table instructor_course_numsBEGINSELECT name INTO name FROM instructor WHERE instructor.id = i_id;SELECT COUNT(*) INTO tot_courses FROM teaches WHERE teaches.id = i_id;SELECT COUNT(*) INTO l_exists_count FROM instructor_course_nums WHERE ID_Number = i_ID; IF l_exists_count > 0THENUPDATE instructor_course_nums SET tot_courses = total_course_nums WHERE ID_Number = i_ID;ELSEINSERT INTO instructor_course_nums VALUES(i_ID, name, tot_courses);END IF;COMMIT; END;
Suppose that a mattress store has a TABLE1 with sales representatives with an attribute vcode as primary key. It also has a TABLE2 with every mattress sold, the table has an attribute vcode to indicate which sales representative made the sale, and a mt_code to indicate which mattress was sold. Which of the following returns all the sales representatives that haven't closed a sale? a. SELECT * FROM TABLE1 LEFT JOIN TABLE2 ON TABLE1.vcode = TABLE2.vcode WHERE mt_code IS NULL. b. SELECT * FROM TABLE1 JOIN TABLE2 ON TABLE1.vcode = TABLE2.vcode WHERE mt_code IS NULL. c. SELECT * FROM TABLE1 RIGHT JOIN TABLE2 ON TABLE1.vcode = TABLE2.vcode WHERE mt_code IS NULL. d. SELECT * FROM TABLE1 RIGHT JOIN TABLE2 ON TABLE1.vcode = TABLE2.vcode WHERE mt_code IS NOT NULL.
how could this sql code alwasy shows "missing right parenthesis"???? its surely have parenthesis. CREATE TABLE lifeexpahelp( REF_DATE varchar(10), GEO varchar(10), DGUID varchar(10) DEFAULT '', Sex varchar(12), Life_Expectancy varchar(12), UOM varchar(10), UOM_ID int, SCALAR_Factor varchar(10), Scalar_ID int, Vector varchar(12), Coordinate varchar(10), Value int, Status varchar(10) default '', Symbol varchar(10) default '', Terminated varchar(10) deafult '', decimals int ); decimals int )Error report -ORA-00907: missing right parenthesis00907. 00000 - "missing right parenthesis"*Cause: *Action:
in the question it said that "Assume that the Reward and Department tables have already been created " so i don't need to create the tables + there is a link from rewards and department to the Employee as in the picture for a reference, my answer is : CREATE TABLE Employee ( EMP_ID CHAR(3) NOT NULL,FNAME VARCHAR(15) NOT NULL,LNAME VARCHAR(15) NOT NULL,SALARY DECIMAL(10,2),JOIN_DATE DATEDEP_NO CHAR(2) NOT NULLPRIMARY KEY(EMP_ID),FOREIGN KEY(EMP_ID) REFRENCE Rewrad,FOREIGN KEY(DEP_NO) REFRENCE Department );is it wrong ?
Create LessonSchedule table with FK constraints in mysql database Two tables are created: Horse with columns: ID - integer, primary key RegisteredName - variable-length string Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the LessonSchedule table with columns: HorseID - integer with range 0 to 65 thousand, not NULL, partial primary key, foreign key references Horse(ID) StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) LessonDateTime - date/time, not NULL, partial primary key If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically.
You have a query that filters a BigQuery table using a WHERE clause on timestamp and ID columns. By using bq query -- -dry_run you learn that the query triggers a full scan of the table, even though the filter on timestamp and ID select a tiny fraction of the overall data a. Create a separate table for each ID. B Use the LIMIT keyword to reduce the number of rows returned. C Recreate the table with a partitioning column and clustering column. D Use the bq query - -maximum_bytes_billed flag to restrict the number of bytes billed.
Hey experts, please help me out on this :( xx Sample database: For all the implemented tasks, your report or output must include a listing of all PL/SQL statements processed. To achieve that put the following SQL*Plus commands in all your scripts:SPOOL file-nameSET ECHO ONSET FEEDBACK ONSET LINESIZE 100SET PAGESIZE 200SET SERVEROUTPUT ONat the beginning of SQL script andSPOOL OFFat the end of SQL script.PARTSUPP table : i. SELECT p_brand, p_type, p_retailpriceFROM part;ii. SELECT count(*)FROM partWHERE p_brand = 'Brand#18';iii. SELECT l_orderkey, count(*)FROM lineitemWHERE l_orderkey = 1184000GROUP BY l_orderkey;iv. SELECT max(ps_suppkey)FROM partsupp;v. SELECT ps_suppkey, ps_partkey, ps_supplycostFROM partsuppWHERE ps_suppkey = 3699AND ps_partkey = 700;
Hello, I am wondering why I am getting an error message when I am trying to execute this code in SQL query management. Here is the code: SELECT xxx m.ManagerID, m.MFName, m.MLName, COUNT(b.BuildingID) AS NumberOfBuildingsManagedFROM xxx HAFHMORE.Manager AS mJOIN HAFHMORE.Building AS b ON m.ManagerID = b.ManagerIDGROUP BY m.ManagerID, m.MFName, m.MLNameHAVING COUNT(b.BuildingID) > 1;\ And this is the error: Msg 102, Level 15, State 1, Line 1Incorrect syntax near '.'.
Create a new table Courses_xxxx with following fields in correct data types.1) cid: varchar(200), unique, NOT NULL, primary key2) name: varchar(200), unique, NOT NULL3) term: varchar(200), NOT NULL4) enrollment: int, NOT NULL5) Fid: int, NOT NULL, a foreign key to TECH3740.Faculty table.6) Rid: int, NOT NULL, a foreign key to TECH3740.Rooms table.7) aid: int, NOT NULL, a foreign key to TECH3740.Admin table.
/* Created with SQL Script Builder v.1.5 */ /* Type of SQL : SQL Server */ CREATE TABLE EMPLOYEE ( EMP_CODE int, EMP_TITLE varchar(4), EMP_LNAME varchar(15), EMP_FNAME varchar(15), EMP_INITIAL varchar(1), EMP_DOB datetime, JOB_CODE varchar(5), STORE_CODE int ); INSERT INTO EMPLOYEE VALUES('1','Mr.','Williamson','John','W','5/21/1964','SEC','3'); INSERT INTO EMPLOYEE VALUES('2','Ms.','Ratula','Nancy','','2/9/1969','MGR','2'); INSERT INTO EMPLOYEE VALUES('3','Ms.','Greenboro','Lottie','R','10/2/1961','GEN','4'); INSERT INTO EMPLOYEE VALUES('4','Mrs.','Rumpersfro','Jennie','S','6/1/1971','GEN','5'); INSERT INTO EMPLOYEE VALUES('5','Mr.','Smith','Robert','L','11/23/1959','GEN','3'); INSERT INTO EMPLOYEE VALUES('6','Mr.','Renselaer','Cary','A','12/25/1965','GEN','1'); INSERT INTO EMPLOYEE VALUES('7','Mr.','Ogallo','Roberto','S','7/31/1962','MGR','3'); INSERT INTO EMPLOYEE VALUES('8','Ms.','Johnsson','Elizabeth','I','9/10/1968','SEC','1'); INSERT INTO EMPLOYEE…
/* Created with SQL Script Builder v.1.5 */ /* Type of SQL : SQL Server */ CREATE TABLE EMPLOYEE ( EMP_CODE int, EMP_TITLE varchar(4), EMP_LNAME varchar(15), EMP_FNAME varchar(15), EMP_INITIAL varchar(1), EMP_DOB datetime, JOB_CODE varchar(5), STORE_CODE int ); INSERT INTO EMPLOYEE VALUES('1','Mr.','Williamson','John','W','5/21/1964','SEC','3'); INSERT INTO EMPLOYEE VALUES('2','Ms.','Ratula','Nancy','','2/9/1969','MGR','2'); INSERT INTO EMPLOYEE VALUES('3','Ms.','Greenboro','Lottie','R','10/2/1961','GEN','4'); INSERT INTO EMPLOYEE VALUES('4','Mrs.','Rumpersfro','Jennie','S','6/1/1971','GEN','5'); INSERT INTO EMPLOYEE VALUES('5','Mr.','Smith','Robert','L','11/23/1959','GEN','3'); INSERT INTO EMPLOYEE VALUES('6','Mr.','Renselaer','Cary','A','12/25/1965','GEN','1'); INSERT INTO EMPLOYEE VALUES('7','Mr.','Ogallo','Roberto','S','7/31/1962','MGR','3'); INSERT INTO EMPLOYEE VALUES('8','Ms.','Johnsson','Elizabeth','I','9/10/1968','SEC','1'); INSERT INTO EMPLOYEE…
/* Created with SQL Script Builder v.1.5 */ /* Type of SQL : SQL Server */ CREATE TABLE EMPLOYEE ( EMP_CODE int, EMP_TITLE varchar(4), EMP_LNAME varchar(15), EMP_FNAME varchar(15), EMP_INITIAL varchar(1), EMP_DOB datetime, JOB_CODE varchar(5), STORE_CODE int ); INSERT INTO EMPLOYEE VALUES('1','Mr.','Williamson','John','W','5/21/1964','SEC','3'); INSERT INTO EMPLOYEE VALUES('2','Ms.','Ratula','Nancy','','2/9/1969','MGR','2'); INSERT INTO EMPLOYEE VALUES('3','Ms.','Greenboro','Lottie','R','10/2/1961','GEN','4'); INSERT INTO EMPLOYEE VALUES('4','Mrs.','Rumpersfro','Jennie','S','6/1/1971','GEN','5'); INSERT INTO EMPLOYEE VALUES('5','Mr.','Smith','Robert','L','11/23/1959','GEN','3'); INSERT INTO EMPLOYEE VALUES('6','Mr.','Renselaer','Cary','A','12/25/1965','GEN','1'); INSERT INTO EMPLOYEE VALUES('7','Mr.','Ogallo','Roberto','S','7/31/1962','MGR','3'); INSERT INTO EMPLOYEE VALUES('8','Ms.','Johnsson','Elizabeth','I','9/10/1968','SEC','1'); INSERT INTO EMPLOYEE…