• Write an SQL query to fetch last_name from employees table using the alias name as Employee Name. • Write an SQL query to fetch unique values of department_id from employees' table. • Write an SQL query to print all employee details from employees table sorted based on first_name ascending.

Correct and detailed answer is must for Upvote. Thank you!

Refer to the film and inventory tables of the Sakila database. The tables in this lab have the same columns and data types but fewer rows. Write a query that lists the titles of films with the fewest rows in the inventory table. This query requires a subquery that computes the minimum of counts by film_id: SELECT MIN(count_film_id) FROM ( SELECT COUNT(film_id) AS count_film_id FROM inventory GROUP BY film_id ) AS temp_table; This subquery is provided in the template.

(Intro to Java)

Create a function to insert a new product into an existing order, include the product id, unit price, quantity. The output of the function is the message to notify the calling program whether the update succeeded or not. note : Note: Sql code need not java  don't waste my time by giving java code

d) Write SQL query to insert the entry ("Shaun", "Paul", "Football", 4) in the table playerEntries(first_name, last_name, category, level).

Question: Which colleges offer courses?    (Change the SQL query to an relational algebra query.) **Please show the resulting tuples output based on your answer as well in a table for further explanation.  ** SELECT COURSE.COLLEGE FROM COURSE, DEPARTMENT WHERE COURSE.DCODE = DEPARTMENT.DCODE;

In a 1024KB segment, memory is allocated using the Buddy System. The following memory allocations are requested. What are the allocated memory for each? (Do not enter K in the answer. Just the numbers) 1. Request 5 KB Requst5KB = 2. Request 135 KB Requst135KB 3. Request 14 KB Requst14KB 4. Request 3 KB Requst3KB 5. Request 12 KB Requst12KB = 6. Request 257KB Requst257KB = The following releases of memory happened. Perform coalescing whenever possible: • Release 3 KB Release 5 KB • Release 14 KB Release 12 KB What is the available memory after coalescing? available [Hint: No need to draw the tree. Looking at the numbers, you can find the answers]

a. Write a query to get all unique first names that start with the letter W from the student table.  Output the names in all upper case. Sort the results in ascending order. Write a query to get the first 3 characters of all last names that start with an T from the student table and sort them in descending order.

Task Write a query to retrieve the records of students who have their total marks greater than or equal to 500 Total marks refer to the sum of the marks of a single student. The result should be in the following format • STUDENT ID • SUM OF MARKS The result should be sorted in descending order by STUDENT D Table description Table: marks Name STUDENT_ID Type Description INTEGER This is the student's unique ID These are the marks obtained STUDENT MARKS INTEGER