List all ‘Assistant’ and add 500 to their salaries, also change the column heading to Salary With Bonus Query to print details for staff with the first name as “Mary” and “John” from Worker table

Q: List all ‘Assistant’ and add 500 to their salaries, also change the column heading to Salary With…

A: Sol 1: Since here table name is not given. So, we are assuming the table name as name_of_table. To…

Q: Delete the EndDate column from the EMPLOYEES table.

A: Deleting column: The Structured Query Language (SQL) alter statement is used when there is a need…

Q: Q.1.3 Alter the EMPLOYEES table to add a column as specified below: EMPLOYEES AGE SMALLINT (5) Q.1.4…

A: NOTE: THIS IS A MULTIPLE-QUESTION-BASED PROBLEM. AS PER COMPANY GUIDELINES WE ARE SUPPOSED TO…

Q: Write query "List the title and publication date for each book in the BOOKS table. Use the column…

A:

Q: Here ,complete the query to displays the unique values of the column:   SELECT ________ dept_name…

A: SELECT ________ dept_name FROM instructor;

Q: Here complete the query to displays the unique values of the column: SELECT ________ dept_name FROM…

A: given: SELECT ________ dept_nameFROM instructor;

Q: Here complete the query to displays the unique values of the column: SELECT ________ dept_name FROM…

A: SQL DISTINCT:- To eliminate duplicate columns from the result set, use the SQL DISTINCT clause. The…

Q: Here complete the query to displays the unique values of the column:   SELECT ________ dept_name…

A: SQL DISTINCT:- To eliminate duplicate columns from the result set, use the SQL DISTINCT clause. The…

Q: Here complete the query to displays the unique values of the column:   SELECT ________ dept_name…

A: The SELECT DISTINCT statement is used to return only distinct (different) values. Inside a table, a…

Q: Here complete the query to displays the unique values of the column: SELECT ________ dept_name FROM…

A: Given, We have to complete the query to displays the unique values of the column. Incomplete Query:…

Q: Alter table supplierTransaction add column paymentDate as data type date, not null, default value of…

A: Query from table Purchase Order ALTER TABLE purchaseOrder RENAME COLUMN WHERE EXISTS (SELECT 1…

Q: Add the OWNER_NUM column as a foreign key in the CONDO_UNIT table.

A: to Add the OWNER_NUM column as a foreign key in the CONDO_UNIT table, the script is mentioned in…

Q: Use Employees table to display the department id and highest salary with the column name "Highest…

A: The Answer is

Q: Display only unique last_name from students table.

A: This question comes from Database Management System which is a paper of Computer Science. Let's…

Q: 13. Add a new column "age" of type small integer to the student table. Then use the following…

A: Answer: 13. ALTER TABLE student  ADD age smallint; UPDATE student SET age=22;   14. SELECT…

Q: Modify the CUSTOMER table to include the customer’s date of birth (CUST_DOB)

A: alter is the command used to modify table add is the command used to add a column to table

Q: Write query "List the title and ISBN of all books using the BOOKS table"

A: Query to display all the records of the books table:   SELECT ISBN, BOOK_TITLE FROM BOOKS;

Q: Write a query to display the author last name, first name, book title, and replacement cost for each…

A: To display the author_last_name,first_name ,book_title and replacement cost and sort the result by…

Q: Write a query to display the movie title, movie year, price description, and price rental fee for…

A: From the given details, we are creating a sample table, with name Movies:

Q: Create a query for displaying list of employees who joined in the second half of year ‘07’;

A: Lets see the solution.

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: Insert data in file customer.sal into table customer

A: Hey, since there are multiple questions posted, we will answer first question. If you want any…

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: Create Table: Staff Write a query to find unique Position from the staff table. List all employees…

A: The first three parts will be solved. 1. CREATE TABLE Staff (  StaffNo number(5) NOT NULL,…

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: Alter the INVOICE_LINE table by adding the INVOICE_NUM column as a foreign key referencing the…

A: Foreign key constraint: It helps to preserve the link between two database relations. This foreign…

Q: Here complete the query to displays the unique values of the column?   SELECT ________ dept_name…

A: Given, Incomplete query: SELECT ________ dept_name FROM instructor; We have to complete…

Q: Here complete the query to displays the unique values of the column?   SELECT ________ dept_name…

A: Given: Here complete the query to displays the unique values of the column?   SELECT ________…

Q: Write a query to produce the total number of hours and charges for each of the projects represented…

A: A query is a way to give instruction to the server to extract data from database. In SQL, SELECT…

Q: write a query to find the last_name that is 4th from the bottom using subquery. (you need to use…

A: In SQL, to select the specific number of records SELECT TOP clause is used. To get the record from…

Q: Which month and year (e.g., March 2017) had the greatest number of ER visits? • The result table…

A: To extract data from a database, the SELECT statement is used. The data is saved in a result table…

Q: Please write a query statement from emp table to display ename, sal, and sal_star for all employees.…

A: Hey there , I am writing the required solution for the above stated question. Please do read the…

Q: If the DOCTORS table has the following columns, and you want to write a SELECT statement to return…

A: If the DOCTORS table has the following columns, and you want to write a SELECT statement to return…

Q: Complete the query to get the EmpFname from the EmployeeInfo table in the upper case using the alias…

A: Given, We have to complete the given query to get the EmpFname from the EmployeeInfo table in the…

Q: Write a query to list the book title, checkout date, checkout due date and checkout in date for each…

A: According to the information given:- We have to write a query on the basic of mention need.

Q: Write a query to get the First and Last Names of all employees who earned more than $70,000 in any…

A: first we need to get the emp_no with salary higher than 70000$ from salary table then get name of…

Q: Write a query to display the department number and most recent employee hire date for each…

A: A query to display the department number and most recent employee hire date for each department is…

Q: Write a query to display the book number, title with year, and subject for each book. Sort the…

A: CONCAT is the operator used to concatenate the values in two columns  ORDER BY is used for sorting

Q: Write a query to display the book number, title, and number of times each book has been checked out.…

A: SELECT CHECKOUT.Book_Num, Book_Title, COUNT(*) 'Times Checked Out' FROM BOOK LEFT JOIN CHECKOUT ON…

Q: Write a query to list the book number, title, and number of times each book has been checked out…

A: Query The query for viewing book number, title and the number of times each book had been checked…

Q: Write a query to find the third-highest bonus from the Employee table. Write a query to retrive the…

A:

Q: Use a query to compute the total of all purchases, the number of purchases, and the average purchase…

A: Step 1. Table creation: Step 2. Inserting values: Step 3. Display the table: Step 4. To calculate…

Q: Use a query to compute the total of all purchases, the number of purchases, and the average purchase…

A: SQL query  The Round() function is used to round off the number to the desired decimal places. The…

Q: Write a query to display the patron ID, full name (first and last), and patron type for all patrons.…

A: - select clause is used to retrieve data from given table and returns data in the form of table. -…

Q: Write a query to display the patron ID, full name (first and last), and patron type for all patrons.…

A: In SQL, to sort the query output "order by" clause is used. In SQL, by default sorting on a…

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: Write query "Rerange the data in ascendimg order based on the cost of the book"

A: Since, here no table is given, So, we are assuming the table books along with some column values.…

Q: Find names of male employees living in Omaha or Lincoln. You should use the two views defined above…

A: A question with multiple parts is asked so we will provide you the answer to the first three parts.…

Q: List all authorswhose last name contains the letter pattern "IN." Put the results in order of last…

A: A Structured Query Language (SQL) code to list all authors whose last name contains the letter…

Q: Select all those professors who age in the range 30 to 40 and don't have any rank. Count the number…

A: SELECT * FROM professors WHERE age>30 AND age<40 AND `rank` IS NULL;