Use the following tables to write the SQL queries:Table Name: EmployeesEMPLOYEE_IDFIRST_NAMEHIRE DATEJOB_IDSALARYDEPARTMENT_ID100Steven02/13/2008AD PRES2400090101Neena05/20/2010AD_VP1700090102Lex09/11/2013AD VP1700090103Alexander09/01/2010IT PROG900060104Bruce01/17/2012IT PROG600060105David02/21/2018IT PROG480060106Vali10/04/2018IT PROG480060107Diana10/06/2019IT PROG420060114Den08/05/2015PU_MAN1100030115Alexander01/14/2016PU CLERK310030Table Name: DepartmentsTable Name: LocationsDEPARTMENT_IDDEPARTMENT_NAMELOCATION_IDLOCATION_IDPOSTAL CODECITYCOUNTRY_ID10Administration1700140026192SouthlakeUS30Purchasing1700150099236South San FranciscoUS50Shipping1500160050090South BrunswickUS170098199SeattleUS60IT14001800M5V 2L7TorontoCA90Executive17001900YSW 9T2WhitehorseCA100Finance17001.Write SQL Command to, display employee id andjob id who gets salary within the range of 4000 and8000.

SELECT keyword is used to display particular columns BETWEEN is the keyword used to specify the…

Answered: 1.Write SQL Command to, display…

Engineering

Computer Science

1.Write SQL Command to, display employee id and ob id who gets salary within the range of 4000 and 8000.

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

2. Write a SQL statement to insert a new user with userId ‘XXXXX’ into the users table and populate at least 5 other columns including column userName. Note: userName column is varchar(20) and its value must be unique in the table users. DO NOT insert into the “created” column but pay attention to it’s value after the insert Paste the SQL below.
plz help in sql In Triggers, BEFORE means before the changes are made in memory but after the changes are permanently saved to disk. Select one: a. True b. False
Database Q1: Select the correct SQL statement to provide the user Samer with read only permission on Employees table a) Grant read on Employee where username = Samer; b) Grant read only on Employee to Samer; c) Grant select to Samer on Employee; d) Grant select on Employee to Samer; Q2: Based on the TWO schema structures below, which SQL statement will create a view to show department names where each department has at least 5 employees? Employee (E_ID, E_Name, D_ID, E_Salary) Department (D_ID, D_Name, D_Address) (Select one) a) Create View Dept_Emp as select D_Name, count(E_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Where count (E_ID) >= 5; b) Create View Dept_Emp as select D_Name, count(E_ID) from Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; c) Create View Dept_Emp as select D_Name, count(D_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; d)…
Write a PL/SQL stored procedure to print number of employees who are working in a job with Title "Tester". Include procedure call also. If the total count of Employees is more than 5 then print "Sufficient number of Employees" If the total count of Employees is less than 5 then print "Insufficient number of Employees" Else print "there are 5 employees". Use Oracle's NO DATA_FOUND build in exception to display the last message. DEPARTMENTS LOCATIONS P DEPARTMENT_ID * DEPARTMENT_NAME MANAGER_ID LOCATION_ID P LOCATION_ID STREET ADDRESS POSTAL_CODE * CITY STATE PROVINCE COUNTRY_ID JOB_HISTORY PF* EMPLOYEE_ID P * START DATE * END DATE F JOB ID F DEPARTMENT_ID EMPLOYEES P EMPLOYEE_ID FIRST NAME * LAST_NAME EMAIL COUNTRIES COUNTRY_ID COUNTRY_NAME F REGION ID PHONE_NUMBER * HIRE DATE F JOB_ID JOBS P JOB_ID * JOB_TITLE MIN_SALARY MAX_SALARY SALARY COMMISSION_PCT MANAGER_ID F REGIONS DEPARTMENT_ID P* REGION_ID REGION_NAME I--
Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 SQL Database Add the four maintenance types to the MAINTENANCE_TYPES table Test Query SELECT * FROM MAINTENANCE_TYPES Expected Results MAINTENANCE_TYPE_ID MAINTENANCE_TYPE_DESCRIPTION MAINTENANCE_PRICE 1 Tire Change 50 2 Oil Change 45 3 Full Cleaning 100 4 Gas Pump Change 145
CREATE TABLE Employee( firstName char(30) , lastName char(30) , hireDate date ,empNo int , empInitial char(30) , years int ); Write the SQL syntax to create an insert statement for the employee table you created above.
13- This clause in SQL join is based on all columns which have the same names, but the data types do not match. a. OUTER JOIN b. USING clause c. ON clause d. NATURAL JOIN
Write Create Table SQL statements based on the above ERD. All tables must have primary keys. All tables must have appropriate foreign key constraints. Foreign keys must have the same name, datatype and size of the primary key that they refer to The following columns datatypes and sizes must be used: bid,authid / number(4) title,sname,fname / varchar2(30) sellingprice, payrate / number(6,2) Table Column Type Range author sname & fname Unique book title Not Null book sellingprice Check not negative allocation payrate Check 1 to 79.99
05. Mention why developers might refer to both, the stored procedures and the SQL CLR stored procedure write a sample code to create a SQL ClR SP
database: sql Q1. Create the following tables: Carrier Attribute name Type Size Constraint carrierID Varchar2 10 Primary key carrierName Varchar2 100 NOT NULL Phone Varchar2 50 LIKE ‘+966%’ Range Varchar2 30 Value is either ‘International’ or ‘Local’ Review Attribute name Type Size Constraint ReviewID INT Primary key Stars INT NOT NULL Comment Varchar2 70 Name Varchar2 50 Default ’User’ CustomerID INT Foreign key references customers ProductID INT
1. SQL Exercise a) Write the SQL Command [//WRITE CODE HERE] name, salary, department [//WRITE CODE HERE] employees_table [//WRITE CODE HERE] start_date >= "2019-01-01"; b) The table and following SQL command will result in how many rows? Invoices Invoice_id date amount 001-8 2019-10-02 35000 001-9 2019-10-02 47000 001-10 2019-10-03 23000 001-11 2019-10-04 10000 SQL SELECT * FROM invoices WHERE invoice_id < "001-10"; a. 0 rows b. 1 row C. 2 rows d. 3 rows c) The following table and SQL command will result in how many rows? catalogs item Full_price sale_price Apple 25 NULL Pizza NULL NULL Cake 120 90 Juice 45 45 SQL SELECT * FROM catalogs WHERE sale_price IS NULL; a. 1 row b. 2 rows c. 3 rows d. 4 rows
code BANK branches N ACCOUNT loanNo enrolls CUSTOMER phone address name Q1. Transform the ERD above to its corresponding Relational Schema. Q2. Using the transform ERD, Write appropriate SQL DDL statement to define the database. Q3. Specify the following queries in SQL. a.) Retrieve all account numbers with balance greater than 100,000. b.) Retrieve the bank name, branch name and account number of each customer account. c.) Find the average loan per branch. Q4. Write SQL update statements to do the following. a.) Insert new customer Manuel Cruz, with social security number of 987-65-4320 who lives at Iligan City and a contact number of 09170000001 b.) Marie Sanchez's loan amount was increased by 15,000. c.) Sergio Ramos opened a checking account with a minimum balance of 150,000 d.) Remove the account record with account number 262262100 name address accountNo SSN M N N offers balance address type N BRANCH loans M applies N branch No LOAN amount type