SQL Query - Order Management
$10-30 USD
Paguhet në dorëzim
To access the datasets, you can use any email address to sign up at [login to view URL]
The tables you’ll need can all be found under brooklyndata.olist_, and you’ll find them hosted on Brooklyn Data's public datasets page in Mode:
[login to view URL]
More about Mode:
● Start a query by clicking the large plus sign in the upper right hand corner of the main page. This database uses PostgreSQL.
● More on the Mode query editor: [login to view URL] Exercise
1. Write a single query that produces the following metrics at order purchase date grain in descending date order: a. . Total orders b. Total customers making orders c. Total revenue d. Average revenue per order e. Top 3 product categories by revenue (by day) f. Percent of day’s revenue associated with each of the top 3 product categories.
2. Using code comments, explain how your query produces each metric.
3. Now that you’ve finished making a pass at your query, it’s always a good idea to get a second set of eyes on your code. Write some notes to your peer reviewer that give some context on the dataset, identify anything notable about your approach, and specify any open questions or concerns you might have about your approach.
4. Sometimes a dataset is not straightforward, and you may need to make some assumptions and validate them later with the business stakeholder. If that is the case, write some notes for the stakeholder, explaining your assumptions, and asking any clarifying questions you may have.
Note: you may translate the product categories if you’d like (with brooklyndata.product_category_name_translation), but that’s not necessary.
ID Projekti: #35606399
Rreth projektit
13 profesionistë freelancer dërguan një ofertë mesatare prej $32 për këtë punë
Hi there.. I'm personal freelancer and interesting with your project are offering and also already read your project description.. so hopefully could help you to provide some SQL / query Order Management from Brookl Më shumë
Hi, Dear. Thanks for posting. I have read your description and I am sure I can do it. please contact me. Thanks. Maksim
Hello Client ! I am a skilled full stack developer. Having rich experience in Java , Python , C , C++ , C# , Mysql , Sql , Oracle , Object Oriented Programming , Data Structure , Algorithms . Më shumë
I WONDER This is miracle! I was just dreaming about project like this. Well, that's what I expected. Hire me, then you could see another miracle. I have rich experiences about such like this project.
Hello, I checked your requirements carefully. I am experienced developer for 10+ years. I'm offering you 100% money back guarantee and ready to get down to work right now. Hope to have a chat soon so I can share my pre Më shumë
Hello there! I am a software developer with 6+ years of experience in developing custom software solutions for businesses. My specialties include web development, database management, and software maintenance. I have Më shumë
Hi! I hope you are having a great day. I have read all the details and requirements of your project carefully. I am very interested in your project . I have an experience about your project and I can start work immedia Më shumë
Dear sir, I can do this job perfectly. These tasks are easy for me. We can discuss more in details here. thank you.
I have good experience of web development and i have good knowledge of database and work of database. I have good development and i will develop the project on time and min cost kindly contact me
Hi Client. I want to help you with my skill, my experience and my effort. I can start to work right now. I am very familiar with MYSQL and SQL and so on. So I can offer excellent results as you want. I am ready. Let's Më shumë