Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(1pd Use the dvdrental database we use in class to solve the following queries. All of these questions below use one or more of the

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
(1pd Use the dvdrental database we use in class to solve the following queries. All of these questions below use one or more of the tables from that database. Question 1 A customer forgot their wallet at our store! We need to track down their email to inforrm them. What's the email for the customer with the name Nancy Thomas? O Type heee to search Question We have two staff members with Staff IDs 1 and 2. We want to give a bonus to the staff member that handled the most payments. How many payments did each staff member handle? And how much was the total amount processed by each staff member e here to search Question 4 .We want to send coupons to the 5 customers who have spent the most amount of money. Get me the customer ids of the top 5 spenders. O Type here to search Question How many films have a rating of R and a replacement cost between $5 and $15? O Type here to search Assignment x e The of VIFY MoviXa () oveand move-YouTube+ O File | file:/l/CA abl . Queries%20m pdf Question ' We want to know what customers are eligible for our platinum credit card. The requirements are that the customer has at least a total of 40 transaction payments. .What customers (by customer_id) are eligible for the credit card? O Type here to search

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 24th International Conference Dexa 2013 Prague Czech Republic August 2013 Proceedings Part 2 Lncs 8056

Authors: Hendrik Decker ,Lenka Lhotska ,Sebastian Link ,Josef Basl ,A Min Tjoa

2013th Edition

3642401724, 978-3642401725

More Books

Students also viewed these Databases questions