Write a query to display the book number, title, and replacement cost for all books in the "Database" subject sorted by book number

Write a query to display the employee number, last name, first name, salary “from” date, salary end date, and salary amount for employees 99675, 53845, and 44035. Sort the output by employee number and salary “from” date.

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

Write a query to get the maximum and minimum salary from the senators table (in that order).

In an OUTER JOIN query, the outer join operator (+) is placed after which table?

Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title “CLERK I.” Sort the output by last name and then by first name

Employee table: (E_Id,E_name,dept_name,Salary) Write Update query Increase salary by 5000 if salary between 30000 to 35000 Increase salary by 7000 if salary between 35001 to 41000 Increase salary by 9000 if salary between 41001 to 46000

Create a query to show the Technician Number, Last Name, First Name, Client Number,and Client Name for clients whose technician number is 23 (use Boolean variables).Save your query

Create a PL/SQL query to display the customer’s name, employee name, donation, dispatch date and the delivery date. In your query, also display the number of days between the dispatch date and the delivery date in days for customer 11013.

Write a query to display the movie title, movie year, price description, and price rental fee for all movies in all categories except for family where the table name is Movies.