i. Retrieve all employees in "sales department" whose salary is between Ksh 30,000 and Ksh 80,000.

Q: i. Retrieve all employees in "sales department" whose salary is between Ksh 30,000 and Ksh 80,000.

A: *Multiple questions*   as per our guidelines we are supposed to answer only one question. Kindly…

Q: Find the first names and last names of employees if they got a salary increase more

A: create table commands and inserting sample data into the table for query  create table employees…

Q: 14. Show the empno, name, hiring date and designation of those employees whose hiredate falls…

A: date 1 and date 2 are read and stored in a variable and used in  the query please use relevant…

Q: Find the first names and last names of employees if they got a salary increase more than 10% in the…

A: create table commands and inserting sample data into the table for query  create table employees…

Q: 18. What happens if you update an instructor's salary to 20000? Why did it happen so? The integrity…

A: If we try to update instructor salary to 20000. It will give error and data will not be updated.…

Q: The property managed by Columbia City with the address "105 North Illinois Rd." is in the process of…

A: We can change the value to null using the below query UPDATE LARGE_PROPERTY  SET BDRMS = null WHERE…

Q: Emp ld First name Anil Last name Salary Overtime Manager_ld 320 10 Ramon 500 18 |16 18 17 18 16 11…

A: 1.) SELECT * FROM Employee WHERE salary > 500ORDER BY Country Manager_id;

Q: StayWell has increased the monthly rent of each large property by $150. Update the monthly rents in…

A: Actually, database is a used to stores the data.

Q: Give 3% salary increase to those employees who have the smallest salary in their respective…

A: UPDATE EMP  SET SAL = (SAL*103)/100 WHERE SAL IN

Q: 1. Retrieve the name of all employees who work in "Research" Department.

A: Query to retrieve the name of all employees who work in research department.

Q: Find the ids and names of professors who have work in two different department on the same time.

A: professors TABLE: Creating professor Table: CREATE TABLE professors(SSN integer, name varchar(25),…

Q: 3. Modify the CUSTOMER table: a) to include the customer's date of birth (CUST_DOB), which should…

A: Actually, database is a used to stores the data.

Q: Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.   Expected…

A: Required: Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.…

Q: What is the difference between the COUNT aggregate function and the SUM aggregate function?

A: Aggregate Functions: SQL has some built-in functions and they are called as aggregate functions.…

Q: I-Show all data from employee table where name should be in ascending and salary in descending…

A: Note: The answer of I and III questions is shown below. Please repost the question with the details…

Q: hy index should not be created for every column of every table of

A: Required: Why index should not be created for every column of every table of database.

Q: i keep getting this message Msg 1778, Level 16, State 0, Line 23 Column 'salesman.salesman_id' is…

A: Given error is Column 'salesman.salesman_id' is not the same data type as referencing column…

Q: 6- Find Customer ID, Customer name and the number of loans for each Customer.

A: As per our guidelines we are supposed to answer only one question. Kindly repost the remaining…

Q: To compute the number of days between your birthday and the current date, which Oracle function…

A: Oracle: Oracle is a database management system (DBMS) and gives developer an IDE to handle the…

Q: use the following data to shown minimum and maximum and average of parts unit price

A: Parts table: Creating parts table: create table parts (PartNo varchar(5)  primary key,Description…

Q: write a MySQL procedure to retrieve and output the item number, description, storehouse number, and…

A: Always prefer to provide database of table.

Q: 4. Display customer ID, customer name, and the order ID and the order date of all orders for…

A: 4) SELECT c.CUSTOMER_ID, c.NAME, o.ORDER_ID, o.ORDER_DATE, oi.QUANTITY AS "Total Items",…

Q: Show the empno, name and designation of those employees whose hiredate falls between two dates…

A:

Q: List the top-3 states that have the most number of employees. Show the state and the number of…

A: List the top-3 states that have the most number of employees. Show the state and the number of…

Q: Using an UPDATE statement, give all cardiologists in hospital 'H120' a 13 % salary increase. Your…

A: Actually, database is used to stores the data or information.

Q: 15. List the first name for all contacts and whether they have a spouse or not (yes/no). Order by…

A: Structured Query Language : SQL ( Structured Query Language) is an area explicit language utilized…

Q: inventory, i.e. the sum of all products on hand for each brand id. Sort the output by brand id in…

A: Here have to determine sql query for given problem.

Q: How can you change "Hansen" into "Hilsen" in the "LastName" column in the "Persons" table? a)…

A: The syntax for UPDATE statement, when updating a table is: UPDATE table_name SET column1_name =…

Q: grade varchar(30), salesman_id int, CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES…

A: The question is to write correct query with respect to the error.

Q: Question:1 Show all data from employee table where name should be in ascending and salary in…

A: NOTE: We’ll answer the first question since the exact one wasn’t specified. Please submit a new…

Q: Question:1 Show all data from employee table where name should be in ascending and salary in…

A: As per Bartleby's answering guidelines if there are multiple questions then only the first three…

Q: Using an implicit cursor, write an anonymous block that will add 25% to the salaries of all…

A: DECLARE sum NUMBER := 0; a NUMBER; BEGIN FOR i in 1 .. 5 LOOP a:=&a;…

Q: Using an implicit cursor, write an anonymous block that will add 25% to the salaries of all…

A: CREATE OR REPLACE PROCEDURE increase_salary (   department_id_in   IN employees.department_id%TYPE,…

Q: Using an implicit cursor, write an anonymous block that will add 25% to the salaries of all…

A: write an anonymous block that will add 25% to the salaries of all employees in department

Q: Using an implicit cursor, write an anonymous block that will add 25% to the salaries of all…

A: A cursor is a pointer to this context area. PL/SQL controls the context area through a cursor. A…

Q: Lael wants to determine several totals and averages for active students. In cell Q8, enter a formula…

A: Given: Lael wants to figure out how many totals and averages there are for active pupils.To count…

Q: 1. Show Student name, reg no, marks and grade from the table Student_info?

A: Note: There are multiple questions are given in one question. According to the rule, you will get…

Q: 18. The HR department needs a report of employees in Toronto. Display the last ame, job, de ment…

A: We are supposed to solve only question, please repost other question.   The query is written for…

Q: 10. When we find out that there are some miss spellings in the query?

A: Given: Where did we discover certain misspellings in the SQL query?

Q: Write a procedure that will accept the same employee identification number, extract and display the…

A: Step 1:-   Introduction:-   To create the table, use the create command   Create table…

Q: Give each clerk a salary increase, which is 3% of all clerks’ average salary to each clerk using…

A: Syntax to find the average of  column in SQL: SELECT AVG(column_name)FROM table_nameWHERE condition;…

Q: Find the nationalities of all users (remove duplicates).

A: As per our company guidelines, we are supposed to answer only one question per question and kindly…

Q: Add the following values in the table Doctor id Doctor_name Degree Join_year Salary D550 Saleh…

A: DOCTOR TABLE: CREATE TABLE DOCTOR(Docotr_id varchar2(5),Doctor_name varchar2(25),Degree…

Q: Question:1 Show all data from employee table where name should be in ascending and salary in…

A: 5. calculate the percentage of any student and round to 0 digit SELECT cast(round((457/500) *100),0)…

Q: Use following oracle table Display the first name and salary*10000 of all employees who works for…

A: Required:     Display the first name and salary*10000 of all employees who works for department 50.

Q: The following table stores details of tutors, students and dates of lectures. The Primary Key is…

A: Rules regarding 2nd NF:-  tables must be in 1st NF.  No non-prime is functionally dependent on part…

Q: Consider the following schema of employees working at Carlson Fabrics Ltd (CFL) and write SQL…

A: Select * From EmployeeWhere emp_name Like 'B%e';

Q: 5) Write an SQL Query to display the accountno, name, Recurrent_acno, amount whose fixed deposit…

A: Required:

Q: Write the standard MYSQL query to retrieve the average customer balance grouped by SalesRepNo Write…

A: I have provided answers in step 2.

Q: What will be the output of the given queries on the given table shown below: Student(SID,…

A: Find the output of the given SQL query after the execution on the given table Student(SID, NAME,…