Q1- List all employees whose job_id is IT_PROG and hired after 01-JAN-95 and earning more than 5000. Q2- List all employee except those with employee_id 101, 102, 103, 104 and 105 Q3- Display the city attribute from locations table. Show the ones that contain “South” in the city. Sort the list in descending order. Q4- Display the first name, last name, salary, manager id and job id of all employees whose last four characters of job id ends with “LERK”. Q5- Display the first name, last name and salary of all employees. Round the salary to the nearest unit of 1000 (ex. Salary=4500 New Salary=5000). Label the column as "New Salary".

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: Examine this product table's column definitions: pid number primary key pname varchar2(50) You must…

A: Given:

Q: Alter the INVOICE_LINE table by adding the INVOICE_NUM column as a foreign key referencing the…

A: Alter table : used to modify column, add column/columns, add constraints, drop column, rename, drop…

Q: Display the maximum price of all the products in PRODUCTS table for each Supplier ID having a…

A: Here we need to join Table Supplier and PID. Since they have common attribute,they can be joined…

Q: Insert into the LARGE_PROPERTY table the office number, address, bedrooms, floors, monthly rent, and…

A: We need to insert some columns from property table to largeproperty table whose square footage is…

Q: 1. Write an SQL query to find the CUSTOMERNAME who order the COMPUTERS. 2. Write an SQL query to…

A: It is defined as a Structured Query Language, is a programming language designed to manage data…

Q: . If the Employees table contains a foreign key named dept_id, is it likely that the values in this…

A: Employee contains primary key of department as foreign key.  This means there is one to many…

Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: List every column in the Condo_UNIT table and its associated typ

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

Q: Show all name and phone numbers of students and the type of donation they received including any…

A: Show all name and phone numbers of students and the type of donation they received including any…

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

A: Answer is given below .

Q: List the number of customers living at each state that is included in the Customer_T table.

A: Query:-

Q: Update the rent of PROPERTY_ID=1 to 1200 using the COLOMBIA_CITY_PROPERTY VIEW.

A: Answer to the above question is in step2.

Q: Every guide receives their first review 6 months after their hire date. List the guide’s last name,…

A: SQL query to display all the list of the guide’s last name, first name, hire date, and his/her first…

Q: 5. Write a query to get the total salaries payable to employees. 6. Write a query to get the…

A: Sorry, we are supposed to answer only three subparts of question ad kindly resubmit the remaining…

Q: Task 6: Add the following record to the OWNER table: INSERT INTO OWNER VALUES('SA100', 'Sam',…

A: Attached the Procedure to add the following record to the OWNER table:   INSERT INTO OWNER…

Q: List the vendor names and address(city, state,zipcode), invoice total for all the vendors who have…

A: There are 2 table which will be joined by outer join. One table contains vendor name,…

Q: Find nth number highest salary. Table:- EMPLOYEE Column Name:- Name,Dept_id,salary,On_Year_Exp.

A: Find nth number highest salary.Table:- EMPLOYEEColumn Name:-Name,Dept_id,salary,On_Year_Exp

Q: List the order number and order date for every order that was placed by Mary Nelson and that…

A: SQL, or Structured Query Language, is a programming language designed for managing and manipulating…

Q: - Copy the name, salary, and commission of each employee hired before 1980 into TEMP table - Copy…

A: INSERT INTO query is used to copy the sql data from one table to another table.WHERE is SQL clause…

Q: Write the following as the MySQL query:  List the employee ID, first name, last name, hire date,…

A: In database administration, it is frequently essential to extract particular data from a dataset…

Q: database HR Display the last name, salary, and commission for all employees who earn…

A: /* Creation of EMP table, I am creating column EMP_FIRST_NAME and EMP_LAST_NAME instead of…

Q: Create a table named 'EMPLOYEE' with the required fields (empno int, first_name varchar(16),…

A: I have provided a detailed answer in the Explanation section.Explanation:Here are the SQL queries to…

Q: Select employee first name, concatenate it with job, find length of department id, find location of…

A: Select employee first name, concatenate it with job, find length of department id, find location of…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: EMPLOYEE TABLE EMPLOYEE_ID FIRST_NAME SURNAME CONTACT NUMBER emp101 0877277521 emp102 emp103 emp104…

A: The queries for creating and inserting data to all tables are given below along with final OUTPUT…

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: Please help with the following What is a valid GROUP BY clause for the following SELECT list?…

A: Given:   Please help with the following What is a valid GROUP BY clause for the following SELECT…

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: 3. Using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from…

A: Using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from the…

Q: For each different job_id group in the employee table, show the average salary and job_id for the…

A: SELECT Average_salary,              Job_id  FROM employees  WHERE EXISTS (SELECT *…

Q: Task 17: List the invoice number and invoice date for each invoice that was created for James…

A: We need to provide a query that lists the invoice number and invoice date for each invoice that was…

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: What is the proper way to insert this into my table?    Insert into Vehicle values…

A: Given: A table Vehicle is created with attributes Vehicle_ID  Vehicle_VIN  Vehicle_Make…

Q: 7. List all customers who were referred to the bookstore by another customer. List each customer’s…

A: The answer to the question is given below: