How to perform analytics on the database table?

Following are the analytics questions to be performed.

What are the top ten genres of choice?

Who are the top ten customers?

What location has the highest number of customers?

What is the preferred method of paying?

What is the average number of rentals?


Please find the attachment herewith of my database table designs

The table is regarding the Video Rental Store.

Please let me know are these tables sufficient enough to get the ans of above questnz?

Arvind Rawat @arvind.rawat
15 Oct 2015 11:45 am

Yes, these tables are sufficient enough to get the required information asked in the question. What i didn't get is what top ten customers meant specifically?

My guess is if it is according to no of transactions performed in total by a customer.