Question: Write a query to display the rental number rental date
Write a query to display the rental number, rental date, video number, movie title, due date, return date, detail fee, and number of days past the due date that the video was returned for each video that was returned after the due date. Sort the results by rental number and movietitle.
Answer to relevant QuestionsWrite a query to display the rental number, rental date, movie title, and detail fee for each movie that was returned on or before the due date (result shown in Figure). Write the SQL code to create a copy of EMP_1, naming the copy EMP_2. Then write the SQL code that will add the attributes EMP_PCT and PROJ_NUM to its structure. The EMP_PCT is the bonus percentage to be paid to each ...Generate a listing of all purchases made by the customers, using the output shown in Figure P7.28 as your guide.Find the customer balance summary for all customers who have not made purchases during the current invoicing period. The results are shown inFigure.Write a query to display the employee number, last name, e-mail address, title, and department name of each employee whose job title ends in the word “ASSOCIATE.” Sort the output by department name and employeetitle.
Post your question