Write a query to display the membership number, last name, and total rental fees earned from that membership (result shown in Figure.). The total rental fee is the sum of all of the detail fees (without the late fees) from all movies that the membership has rented.
Answer to relevant QuestionsWrite a query to display the movie number, movie genre, average movie cost of movies in that genre, movie cost of that individual movie, and the percentage difference between the average movie cost and the individual movie ...Write the two SQL command sequences required to:a. Create a temporary table named TEMP_1 whose structure is composed of the EMP_2 attributes EMP_NUM and EMP_PCT.b. Copy the matching EMP_2 values into the TEMP_1 table. Modify the query used in Problem 29 to produce the summary shown inFigure.Write a query to display the employee number, last name, first name, and sum of invoice totals for all employees who completed an invoice. Sort the output by employee last name and then by firstname.Write a query to display the brand ID, brand name, and average price of products of each brand. Sort the output by brand name. (Results are shown with the average price rounded to two decimalplaces.)
Post your question