4 SQL queries to be written


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.

Taidot: MySQL, PostgreSQL, SQL, Tietokannan hallinto, Tietokantaohjelmointi

Näytä lisää: streamlining sql queries, table sql queries join, write sql queries customer order tables, wordpress custom sql queries, money optimizing sql queries, sql queries check total bulk sms day, fetch sql queries thru loadrunner script, sql queries airline reservation system, wordpress sql queries category, sql queries linux, sql queries oracle date last friday, sample sql queries cricket tournament, aspnet using sql queries crystal reports, whm mysql slow sql queries log, sql queries tree, freelancing sql queries, hello family translation french, sql query find parent child levels, oracle sql queries bank project, sql queries child parent

Tietoa työnantajasta:
( 11 arvostelua ) Sevenoaks, United Kingdom

Projektin tunnus: #20936502

Myönnetty käyttäjälle:


Hi. I have experience in PostgreSQL, so I can write all those queries for you with no problem. Thanks in advance. Best regards.

$20 USD 1 päivässä
(0 Arvostelua)

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!!!

$50 USD 1 päivässä
(170 arvostelua)

Hi. Very good with Postgres and think can help you with tutorial.

$40 USD 3 päivässä
(206 arvostelua)

Hi, there. My name is Lee, and I have 6+ years of experiences in developing websites using PHP, MySQL, HTML & several frameworks. I read your job description, and I am interested in your project. As a dedicated full s Lisää

$25 USD 7 päivässä
(19 arvostelua)

All the above 4 are simple queries. Please reply to get started. Thank you.

$39 USD 1 päivässä
(24 arvostelua)

Hi, I Would like to work for you on writing sql queries in postgresql bases on databases available on the link that you have shared. I have gone through to each of the 4 queries but would need some more clarifications Lisää

$50 USD 1 päivässä
(13 arvostelua)

HI I am expertise in sql querying . ping me if you are interested . i can work for any database system.

$70 USD 1 päivässä
(14 arvostelua)

Hello,How are you? I have read your description in more detail and have much interest in your project. So I think that I can finish your work perfectly as you need.I have many experiences for MySQL. If you need to dis Lisää

$25 USD 7 päivässä
(2 arvostelua)

hi I can do your work as you required. Please come in chat room for more discussion. Awaiting for your response. Thanks & regards Kanyan

$20 USD 1 päivässä
(21 arvostelua)

♫♫♫♫♫♫♫♫ hi! ♫♫♫♫♫♫♫♫ Dear , my Client! i am very pleasure the opportunity to discuss this job with you. i am a full time freelancer with skills and experience on mysql, postgresql, laravel,codeigniter,wordpress and an Lisää

$50 USD 7 päivässä
(7 arvostelua)
$40 USD 2 päivässä
(5 arvostelua)

Hi, I'm very glad to bid your project. I've read your job post carefully. This job really attracts me and also your required skills are completely matched with my major skills. I have good knowledge and rich experienc Lisää

$40 USD 3 päivässä
(3 arvostelua)

Hi, dear! Feel it's the suitable job for me. I have 6 years' experiences in website design and development. I will provide you the best result and satisfaction before your timeline. I am waiting for your message to hav Lisää

$25 USD 1 päivässä
(7 arvostelua)

~~~~Dear Client.~~~~~ Thank you for your posting job. I read your job description carefully and I'm very confident I can complete this project perfectly without any fault. I have already developed many Web sites with p Lisää

$30 USD 2 päivässä
(4 arvostelua)

Hi, I am keen to work for those who need an expert in SQL Language and Database System. More than 7 years experience in many project on SQL, non-SQL, and Database Management such as MS SQL, Oracle, mySQL, Postgresql, M Lisää

$40 USD 2 päivässä
(2 arvostelua)

Dear Client, Nice to meet you. I read your description and have interest in your job now. When I saw your project I knew it was a good fit as I do a lot of this type of work. The following is my introduction. I am a fu Lisää

$25 USD 1 päivässä
(2 arvostelua)

[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.

$20 USD 1 päivässä
(1 arvostelu)

Portfolio : [login to view URL] Cv : [login to view URL] With a Bachelor’s Degree in Electronic Engineering, hands-on experience creating and implementing software applications, and the ability to Lisää

$55 USD 2 päivässä
(0 arvostelua)

I have read the DVD rental database that you posted in the descripcion and I have the analysis in order to write the 4 the sql queries.

$22 USD 2 päivässä
(0 arvostelua)

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

$25 USD 7 päivässä
(0 arvostelua)

Well, Brother i think i am perfect for this task. because i did completed this before. If you are interest i can do it according to yours document. if you need little changes. I will do cheap rate. dont worry about it. Lisää

$25 USD 7 päivässä
(1 arvostelu)