Chapter 3, Problem 3.15CP

What’s the difference between the UNION and UNION ALL set operators?

There's a "friend_requests" table that has a column "action_taken" that displays if the friend request was rejected, requested, or accepted.Implement a SQL query to return the number of "action_taken" that were "accepted".

In order to figure out how many days have passed since your birthday and the current date, you need to use an Oracle function to do it.

ignore the Answer:frequence

In the SQL Oracle Application Write one query to return the employee_id, job_id, hire_date, and department_id of all employees and a second query listing employee_id, job_id, start_date, and department_id from the job_history table and combine the results as one single output. Make sure you suppress duplicates in the output.

My other instruction for SQL says: Create and test a stored procedure called checkin_transaction that processes a “checkin” transaction. When a book is checked in, the corresponding CHECKOUT record is updated to show the date it was checked in, and the Pat_ID attribute in the BOOK table is updated to NULL.  The entire transaction (starting with START TRANSACTION; and ending with COMMIT;) should be in between the BEGIN and END statements of the stored procedure.  You should be able to call the procedure with a statement like this, passing the values of the Book_Num, Pat_ID, and Check_In_Date to the procedure:   CALL checkin_transaction(5243, 1170, ‘2017-04-30’) Do you guys know how?

Using Sakila DB, create a function to get all the film titles for a given Actor. Example: getFilmTitle('firstname','lastname') Will return all the movies acted by the Actor. Put the screenshot of the implementation if you can.

How do I create a function in Python Mongo DB that asks a user if the want to insert, update, or delete information (name & street_address) in my collection and excute the actions?

_________are the access specifiers in order of most restrictive to least