October 15, 2018 at 4:15 am
Hello
i will appreciate if you tell me the sql queries that i need in the following questions ( i am new to sql)
"In a pre Netflix era, the owner of a DVD rental business wants to improve her understanding on certain aspects and gain some advantages running the business. This is why she ask few questions:
1. How many rentals do we do per month?
2. How big is our customer base? How many of those have been active at any given month?
3. What are the top performing film categories?
4. What other insights could we squeeze out of this data and what decisions could we drive based on this ? ( i need sql queries + suggestion for a potential “killerinsight”)
database schema.
http://www.postgresqltutorial.com/postgresql-sample-database/
thanks in advance
October 15, 2018 at 4:28 am
That link is to a PostgreSQL tutorial, however You've posted on a SQL Server Community website. SQL Server and PostgreSQL are 2 completely different RDBMS.
As for your question, this reads like homework anyway, not something the volunteers here (and on many other community websites) will be happy to do for you. Homework should be completed by the person who it was assigned to, not by some strangers on the internet. I suggest having a go at this yourself, and if you struggle speak to your tutor.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 16, 2018 at 6:31 am
gxdatareal - Monday, October 15, 2018 4:15 AMHello
i will appreciate if you tell me the sql queries that i need in the following questions ( i am new to sql)"In a pre Netflix era, the owner of a DVD rental business wants to improve her understanding on certain aspects and gain some advantages running the business. This is why she ask few questions:
1. How many rentals do we do per month?
2. How big is our customer base? How many of those have been active at any given month?
3. What are the top performing film categories?
4. What other insights could we squeeze out of this data and what decisions could we drive based on this ? ( i need sql queries + suggestion for a potential “killerinsightâ€)
database schema.
http://www.postgresqltutorial.com/postgresql-sample-database/
thanks in advance
And perhaps more critical, you've posted a question for which you provide no data structure AND no indication that you've even made any attempt to figure this out. Of course, with no data structure, there's actually no possible way to figure out ANY of the details. As most small business owners are unlikely to have a grounding in relational databases, the likelihood that they have even computerized their data is relatively low to begin with. That kind of business hasn't had any decent profit in it for a rather long time, and thus I'm doubtful that the expenditure on that kind of exercise is even worth the money.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply