the table structures and columns name should be implemented in the coding

and its is one question with some sub parts so tell me about the chegg policy and stuff. All the information is given in the slides and I will be doing this in SQL so pls answer them accordingly

Course INFO 2312: De x D Lab2-Oueries(1),pdt x The Official Home of Y xC Get Homework Hepb C es overland movie | New Tab Good Eert Deiete r SX+ File | file:///C a t Lab2-Queries (1)-pdf 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 A customer forgot their wallet at our store! We need to track down their email to inform them. What's the email for the customer with the name Nancy Thomas? O Type here to search ^ aENG 2019-02-10 Course INFO 2312: De x D Lab2-Oueries(1),pdt x The Official Home of Y xC Get Homework Hepb C Good Lert Deiete F S x + es overland movie | New Tab File | file:///C a t Lab2-Queries (1)-pdf 3 17 Question Use a SELECT DISTINCT statement to get the distinct rating types our films can have in our database. O Type here to search ^ ENG 4:48 PM Course INFO 2312: De x D Lab2-Oueries(1),pdt x The Official Home of Y xC Get Homework Hepb C Good Lert Deiete F S x + es overland movie X New Tab File | file:///C a t Lab2-Queries (1)-pdf 4 17 Question 3 . 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 O Type here to search rP ^ ENG 2019-02-10 Course INFO 2312: De x D Lab2-Oueries(1),pdt x The Official Home of Y e Get Homework Help V Good tert Deietes: es overland movie | New Tab x X x O File file:/!/C a t Lab2-Queries (1)-pdf 5 17 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 rP ^ ENG 2019-02-10 Course INFO 2312: De x D Lab2-Oueries(1),pdt x The Official Home of Y xC Get Homework Hepb C es overland movie | New Tab Good Eert Deiete r SX+ O File file:/!/C a t Lab2-Queries (1)-pdf 6 17 Question How many films have a rating of R and a replacement cost between $5 and $15? O Type here to search rP ^ ENG 2019-02-10 Course INFO 2312: De x D Lab2-Oueries(1),pdt x The Official Home of Y xC Get Homework Hepb C es overland movie X New Tab Good Eert Deiete r SX+ File | file:///C a t Lab2-Queries (1)-pdf 7 17 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 rP ^ ENG 2019-02-10 custamer Microsoft Excel Hcme ert Page Layaun Fonulas Daa Rev Visw Team Cit Autasum Bat FI 2 ClearSort &Find & Edting Paste / Fcrmst Pointtr B 1- , Jr . . . # S . % , 2:31 Conditional Forme as Neutral Calculation Check Cel ert Delete Forma F Merge & Center Formatting Table Fiter Select first name last name username Tom Hanks 1001 1010 lason 2001 Chirimaya Mahapatrchinnays.natapalrakpu.ca 17 O Type here to search 448 PM 2019-02-10 employee 1 Micrcsoft Excel Hcme ert Page Layaun Fonulas Daa Rev Visw Team Cit Autasum Norial Bat Fil 2 ClearSort &Find & Edting Paste / Fcrmst Pointtr B 1- , Jr . . . # S . % , 2:31 Conditional Forme as Neutral Calculation Check Cel ert Delete Forma F Merge & Center Formatting Table Fiter Select 1001 Latham Junior les 50O0 12/11/200 M software80000 01/01/199M Stewartsaftware 75000 23/04/199M 2001 Jason Joy 2002 Lee 3001 Mary Luce Te Lea90000 15/12/199 F 005 Martha stuart Manager 95000.4 07 07/199F 4001 William an 105000.5 12/12/198M 17 O Type here to search 448 PM 2019-02-10 order table-Micrasaft Exce Hcme ert Page Layaun Fonulas Daa Rev Visw Team Cit copy Autasum Bat 2 ClearSort &Find & Edting Paste / Fcrmst Pointtr B 1- , Jr . . . # S . % , 2:31 Conditional Forme as Neutral Calculation Check Cel ert Delete Forma F Merge & Center Formatting Table Fiter Select product price 1001 firctv 49.99 69.99 ansurigtw 1549.99 1797.5 1650 1297.98 2 1010 firetv4k 1001 1001 sonyt S1010 Istv 1010 viziotv 17 O Type here to search 448 PM 2019-02-10