I need the following SQL queries to be written using the sample postgres database:
[login to view URL]
1. Create a query that lists each movie, the film category it is classified in, and the number of times it has been rented out.
2. Can you provide a table with the movie titles and divide them into 4 levels (first_quarter, second_quarter, third_quarter, and final_quarter) based on the quartiles (25%, 50%, 75%) of the rental duration for movies across all categories?
3. Provide a table with the family-friendly film category, each of the quartiles, and the corresponding count of movies within each combination of film category for each corresponding rental duration category. The resulting table should have three columns: Category; Rental length category; Count
4. Write a query that returns the store ID for the store, the year and month and the number of rental orders each store has fulfilled for that month. Your table should include a column for each of the following: year, month, store ID and count of rental orders fulfilled during that month.
31 freelanceria on tarjonnut keskimäärin 31$ tähän työhön
Hello there, i'm expert on PostgreSQL, also writing complex queries, let me help you with this. I think i can finish these 4 in a couple of hours. Waiting for your response if interested. Thank you!!!
[login to view URL] an experienced developer, I am very interested in the job. Especially I have a talent in SQL. Now I am ready to work for you. Best regards.
hi, I have read your project requirements and i am having great experience in database. i will definitely do this work for you. Waiting for your prompt reply. Regards Harman